How do you list applicants from the highest score to the lowest?

Comment lister les candidats de la note la plus haute à la plus basse ?

Answers

ASELECT Name, Score FROM Applicants ORDER BY Score DESC;SELECT Name, Score FROM Applicants ORDER BY Score DESC;

BSELECT Name, Score FROM Applicants ORDER BY Score ASC;SELECT Name, Score FROM Applicants ORDER BY Score ASC;

CSELECT Name, Score FROM Applicants SORT Score UP;SELECT Name, Score FROM Applicants SORT Score UP;

DSELECT Name, Score FROM Applicants WHERE Score DESC;SELECT Name, Score FROM Applicants WHERE Score DESC;

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