Q. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

(A) SELECT * FROM Persons SORT BY ‘FirstName’ DESC
(B) SELECT * FROM Persons ORDER FirstName DESC
(C) SELECT * FROM Persons SORT ‘FirstName’ DESC
(D) SELECT * FROM Persons ORDER BY FirstName DESC

💬 Discuss

✅ Correct Answer: (D) SELECT * FROM Persons ORDER BY FirstName DESC

Published by Mr. Dubey ⭐ 111.54K Points at 16-Sep-2023 03:24 pm in Database Management System (DBMS)

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

919

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

81%

Success Rate