The ORDER BY clause used to sort the sql query results in 

ascending or in descending order

Following are some SQL questions and answers, you may require it.

if we need some fields from different tables
temporarily in our software or application then

connecting Asp.net local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -

It's a good idea to use a class say gateway where all
database access codes will be written.in this gateway class
you will implement db connection as follows -

first create another class -