Learn SQL

ORDER BY

20.3

Lesson

# Order students by grade and marks

Find the name, grade, and marks of students, in the increasing order of grade.

For Grade 10 we have three students. Now we want these three students to be sorted based on their marks.
In this case, we can specify multiple columns after `ORDER BY`

separated by `,`

to get the result.

Let’s reverse the order of columns mentioned in the `ORDER BY`

clause.

Notice the difference in results from the earlier query.
The results are sorted in the order of `marks`

first and then `grade`

.
`ORDER BY`

sorts the result in the order in which the column names are mentioned. So the data is first sorted in the order of the first column in the `ORDER BY`

list, and then in the order of the second column, and so on.