row_number() OVER (ORDER BY a.groupname) AS id code example

Example: sql query row number group by

SELECT 
   Date,    
   ROW_NUMBER() OVER (PARTITION BY Date ORDER By Date, Cat) as ROW,
   Cat,
   Qty
FROM SOURCE