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

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

📊 Database Management System (DBMS)

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

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

878

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

97%

Success Rate