Learn SQL

ORDER BY

20.1

Lesson

# Order students by marks

Find names of all students with their corresponding marks.

Now, we want to display the same data, but the marks should be sorted in the increasing order.
We can use `ORDER BY`

to solve this problem.

The data appears with marks in the increasing order.
`ORDER BY`

sorts the data as per the order of the column mentioned next to it.