Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CASE WHEN _rank = 1 THEN name ELSE '' END AS name, amount
- FROM (
- SELECT name, amount,
- ROW_NUMBER() OVER (PARTITION BY name ORDER BY amount ASC) AS _rank
- FROM t1
- ) q
- SELECT CASE WHEN _rank = 1 THEN name ELSE '' END AS name, amount
- FROM (
- SELECT name, amount,
- ROW_NUMBER() OVER (PARTITION BY name ORDER BY amount ASC) AS _rank
- FROM t1
- ) q
Add Comment
Please, Sign In to add comment