Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with t1 as
- (select Sale_Day, Item_ID,
- SUM(rate * quantity) Total,
- row_number() OVER(partition by Sale_Day
- ORDER BY SUM(rate*Quantity) desc) as rn
- FROM scratch
- GROUP BY Item_ID, rate, quantity, Sale_Day)
- --select * FROM scratch
- select Sale_Day, Item_ID, Total
- from t1
- WHERE rn = 1
- ORDER BY Sale_Day
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement