Answers for "sql take 1 from group rownumber and where clause"

SQL
0

sql query row number group by

SELECT 
   Date,    
   ROW_NUMBER() OVER (PARTITION BY Date ORDER By Date, Cat) as ROW,
   Cat,
   Qty
FROM SOURCE
Posted by: Guest on January-23-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language