Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with scores as
- (select
- row_number() over (order by score desc) as rn,
- name,
- score
- from
- players)
- select
- name,
- score
- from
- scores
- where
- score in (select score from scores where rn = 3)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement