C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !





Posted By: sachin mali       Member Level: Gold       Posted Date: 26 Mar 2008       Category: SQL Server

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



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


Select Answer:

SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER FirstName DESC




      
Your Test Score: 0 / 0



Next Question: Which SQL keyword is used to sort the result-set?
Previous Question: With SQL, how can you insert a new record into the "Persons" table?
Related Questions:
  • Query to view the transaction log from the master database


  • What will be the output?


  • Which is not the DML statement from following?


  • Function to find the difference between the minute in 2 dates


  • Which virtual table does a trigger use


  • Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.


    dotNet Slackers   BizTalk Adaptors    Web Design


    Contact Us    Privacy Policy    Terms Of Use