Re:SQL: Select only rows with Max Value on a Column
by baxter001 on Tuesday December 31, 2013 @05:40PM
(#6993246)
Or those who happen to be using a dialect of sql with window functions, selecting the rows where:
ROW_NUMBER() OVER(PARTITION BY Id ORDER BY Rev DESC) AS "Row Number"
Returns 1 is clearer to my mind, with some caveats around dialects which use separate forms of row-number that assign identical/differing numbers to two consecutive identical rows.
ROW_NUMBER() OVER(PARTITION BY Id ORDER BY Rev DESC) AS "Row Number"
Returns 1 is clearer to my mind, with some caveats around dialects which use separate forms of row-number that assign identical/differing numbers to two consecutive identical rows.
I hate joins. Subselects are so much clearer imo - and you don't end up with extra fields.