R

Ram Sharma • 193.86K Points
Coach 

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

  • (A) SELECT * FROM Persons ORDER BY FirstName DESC
  • (B) SELECT * FROM Persons SORT ‘FirstName’ DESC
  • (C) SELECT * FROM Persons ORDER FirstName DESC
  • (D) SELECT * FROM Persons SORT BY ‘FirstName’ DESC
  • Correct Answer - Option(A)
  • Views: 133
  • Filed under category SQL Server

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on SQL Server

Q. DecryptByKeyAutoCert is ________________ type function.

Q. SQL server 2005 never combined the administrative feature of query analyzer

Q. A database typically has ………. Components

Q. Which of the following feature of SQL Server was used before XML technology for semi structured data?

Q. Embedded SQL is which of the following?

Q. Which of the following is used to overcome the Replication in SQL Server?

Q. Unrestricted execution policy can be set up in SQL Server can be done using __________

Q. What is the full form of SQL.

Q. Point out the correct statement.

Q. Which of the following is not a limitation of view?

Learn All SQL Server MCQs

Question analytics