RivoCode

SQL Fundamentals · Filtering & Sorting · Lesson 7 of 17

Sorting with ORDER BY

Concept

Sorting with ORDER BY

ORDER BY sorts query results by one or more columns, ascending by default or descending with DESC.

By the end of this lesson
  • Explain the core idea behind Sorting with ORDER BY.
  • Predict output before running a change.
  • Test one realistic and one unusual input.
  • Use the result to make the next decision.
How to study this page
  1. 1. Read one concept.
  2. 2. Change the example.
  3. 3. Run, compare, and explain.
  4. 4. Complete the challenge below.
ExampleRunnable
SELECT name, age FROM students
ORDER BY age DESC;
Try it Yourself »
Self-check before continuing

Without looking at the example, describe what changes when you modify one input in Sorting with ORDER BY. Then reopen the editor and prove your explanation with a small test.

You are ready to continue when you can predict, test, and explain the result.

Your turn

Write a query that sorts students by name in ascending order.

Loading editor…

Console

Output will appear here...