MySQL ORDER BY

ORDER BY sorts the result. The default is ascending (ASC): A to Z and small to big. Use DESC for the opposite.

SELECT name, marks FROM students ORDER BY marks DESC;

SELECT name FROM students ORDER BY name;

---

Sort by more than one column

If two rows have the same value in the first column, MySQL looks at the second one.

SELECT name, city, marks FROM students
ORDER BY city ASC, marks DESC;

The cities are in A to Z order, and inside each city the highest marks come first.

---

With WHERE

ORDER BY comes after WHERE.

SELECT name, marks FROM students WHERE marks > 60 ORDER BY marks;

---

Summary

• ORDER BY column ASC|DESC sorts the result.
• Many columns are separated by commas.
• Next: LIMIT.

• Previous Page
• Next Page

---

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.