SQL ORDER BY Clause
Retrieving data in a meaningful order is crucial for readability and analysis. The SQL ORDER BY clause sorts records by one or more columns in ascending (ASC) or descending (DESC) order.
Complete Python Course with Advance topics:-
SQL Tutorial:-
Syntax
-- Ascending
SELECT * FROM TableName ORDER BY ColumnName ASC;
-- Descending
SELECT * FROM TableName ORDER BY ColumnName DESC;
-- Default (ascending if no keyword)
SELECT * FROM TableName ORDER BY ColumnName;Note: If neither ASC nor DESC is specified, SQL sorts in ascending order by default.
Example 1: Sort by Name (Ascending)
SELECT * FROM customers ORDER BY Name ASC;Example 2: Sort by Salary (Descending)
SELECT * FROM customers ORDER BY Salary DESC;Sorting by Multiple Columns
You can sort by several columns ÔÇö the second column breaks ties in the first:
SELECT * FROM customers
ORDER BY Address ASC, Salary DESC;Download New Real Time Projects:- Click here
Complete Advance AI topics:-
Conclusion
The ORDER BY clause organizes data effectively ÔÇö alphabetically, numerically, or chronologically. Use ASC for ascending, DESC for descending, and sort by multiple columns for fine control. For more SQL tutorials, stay tuned to .
sql order by clause
sql order by multiple columns
sql group by clause
sql server order by clause
sql order by desc limit 1
sql order by desc null last
sql order by clause example
order by clause in sql
