In PostgreSQL or MySQL, how do you return only the 10 highest-scoring applicants?

Sous PostgreSQL ou MySQL, comment ne renvoyer que les 10 candidats ayant les meilleures notes ?

Answers

ASELECT * FROM Applicants WHERE ROWNUM = 10 ORDER BY Score DESC;SELECT * FROM Applicants WHERE ROWNUM = 10 ORDER BY Score DESC;

BSELECT * FROM Applicants ORDER BY Score DESC LIMIT 10;SELECT * FROM Applicants ORDER BY Score DESC LIMIT 10;

CSELECT 10 FROM Applicants;SELECT 10 FROM Applicants;

DSELECT * FROM Applicants FIRST;SELECT * FROM Applicants FIRST;

The answer and explanation are in the full bank.

This question is one of 2,831 in the paid banks. Each comes with the correct answer and the reasoning behind it, not just a mark.

MIFOTRA exam practicealigned to Practice set: Database Management·1 mark·Easy

More Database questions