Guest User

Untitled

a guest
Jun 23rd, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT CASE WHEN _rank = 1 THEN name ELSE '' END AS name, amount
  2. FROM (
  3. SELECT name, amount,
  4. ROW_NUMBER() OVER (PARTITION BY name ORDER BY amount ASC) AS _rank
  5. FROM t1
  6. ) q
  7.  
  8. SELECT CASE WHEN _rank = 1 THEN name ELSE '' END AS name, amount
  9. FROM (
  10. SELECT name, amount,
  11. ROW_NUMBER() OVER (PARTITION BY name ORDER BY amount ASC) AS _rank
  12. FROM t1
  13. ) q
Add Comment
Please, Sign In to add comment