Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select nome_jogador,pontuacao
- from jogador
- where pontuacao > (select pontuacao from jogador where id_jogador='4') limit 2
- union
- select nome_jogador,pontuacao
- from jogador
- where pontuacao < (select pontuacao from jogador where id_jogador='4') limit 2
- union
- select nome_jogador,pontuacao
- from jogador
- where id_jogador='4' order by pontuacao desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement