How to sort SQL descending order

In SQL, you can use the ORDER BY clause to sort the query results in descending order. The specific syntax is: ORDER BY column name DESC, where the column name is the column to be sorted, and DESC represents descending order arrangement.

Operations for descending order in SQL

In SQL, query results can be sorted in descending order by using the ORDER BY clause. The syntax is as follows:

 <code>ORDER BY 列名DESC</code>

Where,列名is the column to be sorted, and DESC keyword represents the descending order arrangement.

Example

For example, consider a table of students with student grades:

 <code>| id | name | score | |---|---|---| | 1 | John | 85 | | 2 | Mary | 92 | | 3 | Bob | 88 | | 4 | Alice | 95 |</code>

To sort the grades in descending order, you can use the following query:

 <code>SELECT * FROM students ORDER BY score DESC;</code>

The results are as follows:

 <code>| id | name | score | |---|---|---| | 4 | Alice | 95 | | 2 | Mary | 92 | | 3 | Bob | 88 | | 1 | John | 85 |</code>

As you can see, students' grades are arranged in descending order.

The above is the detailed content of How to sort SQL descending order. For more information, please follow other related articles on the PHP Chinese website!