Advertisement
Guest User

why is this not working?

a guest
Feb 26th, 2020
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. with t1 as
  2. (select Sale_Day, Item_ID,
  3. SUM(rate * quantity) Total,
  4. row_number() OVER(partition by Sale_Day
  5. ORDER BY SUM(rate*Quantity) desc) as rn
  6. FROM scratch
  7. GROUP BY Item_ID, rate, quantity, Sale_Day)
  8.  
  9. --select * FROM scratch
  10.  
  11. select Sale_Day, Item_ID, Total
  12. from t1
  13. WHERE rn = 1
  14. ORDER BY Sale_Day
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement