MySQL Tutorial

A database system used with PHP.

Chapter Quiz Exercises
Course Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views

MySQL ORDER BY

The MySQL ORDER BY Keyword

The ORDER BY keyword is used to sort the result-set in ascending or descending order.

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

Syntax:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;

Try It Yourself

Edit the code below and click Run to see the result live.

Source Code
Result
Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views