SQL ORDER BY – Tutorialpath

SQL | ORDER BY

The ORDER BY statement in SQL is used to sort the fetched data in either ascending or descending according to one or more columns.

  • The Order by clause by default sorts the retrieved data in ascending order.
  • To sort the data in descending order DESC keyword is used with Order by clause.

Syntax

The basic syntax of the ORDER BY clause is as follows −

SQL ORDER BY
SQL ORDER BY

Parameters or Arguments:

Expressions
The columns or calculations that you wish to retrieve.
Tables
The tables that you wish to retrieve records from. There must be at least one table listed in the FROM clause.
WHERE conditions
Optional. Conditions that must be met for the records to be selected.
ASC
Optional. ASC sorts the result set in ascending order by expression. This is the default behavior, if no modifier is provider.
DESC
Optional. DESC sorts the result set in descending order by expression.

Sort according to multiple columns: To sort in ascending or descending order we can use the keywords ASC or DESC respectively. To sort according to multiple columns, separate the names of columns by (,) operator.

 

  • Sort according to single column: In this example we will fetch all data from the table Student and sort the result in descending order according to the column ROLL_NO.

Output:

Sort according to single column: In this example we will fetch all data from the table Student and sort the result in descending order according to the column ROLL_NO.

Output:

Leave a Reply

Your email address will not be published. Required fields are marked *