MySQL SORT

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

The MySQL ORDER BY clause is used to sort the data in ascending or descending order.

The basic syntax of the ORDER BY clause which would be used to sort the result in an ascending or descending order is as follows −


SELECT column-list 
FROM table_name 
[WHERE condition] 
[ORDER BY column1, column2, .. columnN] [ASC | DESC];

Let's put these statements into real use.

We've a table named Students in our database that contains the following records:

We will use 'ASE' keyword to ascending sort.


SELECT * FROM Students
ORDER BY NAME ASC;

The above SELECT statement selects all from Students table and sorted low to High by their NAME:

Now we will fetch records from the Students table with Descending order.

We will use 'DESC' keyword to ascending sort.


SELECT * FROM Students
ORDER BY NAME DESC;

The above SELECT statement selects all from Students table and sorted High to low by thier NAME:

WE can also Sort Students table using their ROLL_NO,SUBJECT.

« Previous Next »

MySQL - SORTING