SQL ORDER BY

SQL ORDER BY

SQL ORDER BY

SQL ORDER BY

     

The ORDER BY keyword sort the table result set by a specified column. You want to sort the records in ascending order,  you can use the ASC keyword. If you want to sort the records in descending order,  you can use the DESC keyword. Records sort from the table in ascending order by default.

Understand with Example

The Tutorial illustrates an example from SQL ORDER BY. In this example, we create a table 'Stu_Table'. The create table statement is used to create a table into your database.

Create Table Stu_Table

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class  varchar(10))

Insert data into Stu_Table

Insert into statement insert the records into table.

insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);
insert into Stu_Table values(1,'Komal',10);

Stu_Table

The select statement return you the record from table 'Stu_Table'. 

Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10
1 Komal 10

SQL ORDER BY Syntax

The ORDER BY keyword sort the table result set by a specified column.

SELECT ColumnName(s)
FROM TableName
ORDER BY ColumnName(s)

SQL ORDER BY Query

In this Example, we use Order By Query on table 'Stu_Table'.The Order by Query return you the sorted records from the table in ascending order  by Stu_Name.

SELECT Stu_Id, Stu_Name, Stu_Class
FROM Stu_Table
ORDER BY Stu_Name 

Result

 output of the above SQL Query will be

Stu_Id Stu_Name Stu_Class
2 Ajay 10
4 Bhanu 10
1 Komal 10
1 Komal 10
3 Rakesh 10
5 Santosh 10

SQL ORDER BY Query

In this example, we sort the records from a table in descending order by Stu_Id.

SELECT Stu_Id, Stu_Name, Stu_Class
FROM Stu_Table
ORDER BY Stu_Id DESC

Result

Stu_Id Stu_Name Stu_Class
5 Santosh 10
4 Bhanu 10
3 Rakesh 10
2 Ajay 10
1 Komal 10
1 Komal 10