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.