Advertisement
Guest User

why is this working?

a guest
Feb 26th, 2020
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT Sale_Day, Item_ID, Total
  2. FROM
  3. (
  4. SELECT Sale_Day, Item_ID,
  5. SUM(Rate*Quantity) Total,
  6. RANK() OVER(PARTITION BY Sale_Day ORDER BY SUM(Rate*Quantity) DESC) rank
  7. FROM scratch
  8. GROUP BY Sale_Day, Item_ID
  9. ) a
  10. WHERE rank = 1
  11. ORDER BY Sale_Day
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement