I would do something like this: ;WITH x AS (SELECT *, Row_number() OVER( partition BY employeeid ORDER BY datestart) rn FROM ... ... <看更多>

Even more interesting, if I re-write the third query like this (swap two columns): SELECT -- both ID,A,B,C ,ROW_NUMBER() OVER (PARTITION BY ... ... <看更多>

One issue I've come across is that ROW_NUMBER() window functions generated by dbplyr produce errors. For example, if I run this code: flights %> ... ... <看更多>