> > >

ASP.NET With SQL Server MCQs

What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?

SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC

SELECT * FROM Persons SORT REVERSE ‘FirstName’

SELECT * FROM Persons ORDER BY ‘FirstName’

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER BY DESC FirstName

Answer

Correct Answer: SELECT * FROM Persons ORDER BY FirstName DESC

Explanation:

Note: This Question is unanswered, help us to find answer for this one

ASP.NET With SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More ASP.NET With SQL Server MCQ Questions

ASP.NET With SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it