Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Explain ORDER BY Clause in SQL ?

The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some database sorts query results in ascending order by default.

 

Syntax:

 

SELECT [distinct] <column(s)>

from table_name [ WHERE <condition> ]

[ ORDER BY <column(s) [ASC|DESC]> ]

Related Posts Plugin for WordPress, Blogger...
Flag Counter