SQL ORDERBY CLAUSE

The SQL ORDER BY clause is used for sorting data in ascending and descending order based on one or more columns.

SQL Orderby Syntax

SELECT expressions  
FROM tables  
WHERE conditions  
ORDER BY expression [ASC | DESC];

This statement is used to sort data in ascending order.By default sql use ascending.

syntax


SELECT column_name 
FROM table_name 
WHERE column_name2 = 'xyz'  
ORDER BY column_name3;

This statement is used to sort data in descending order.

syntax


SELECT column_name  
FROM table_name 
WHERE column_name2 = 'xyz'  
ORDER BY column_name3 DESC;

It fetch random data from database table.

syntax


SELECT column FROM table  
ORDER BY RAND ()  
LIMIT 1

It can be used retrieve limited rows from the database.

syntax

SELECT * FROM table_name
WHERE column_name ="?" LIMIT 10