How to write descending order in sql

Descending sorting can be achieved in SQL by using the DESC keyword. Syntax: SELECT column_name(s) FROM table_name ORDER BY column_name DESC; For example, to sort employees in descending order by the salary column: SELECT name, salary FROM employees ORDER BY salary DESC.

Descending sort in SQL

In SQL, the method to implement descending sort is very simple, you can use Keyword DESC.

Syntax:

<code class="sql">SELECT column_name(s)
FROM table_name
ORDER BY column_name DESC;</code>

Example:

Suppose we have the following table:

<code class="sql">CREATE TABLE employees (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    salary INT NOT NULL,
    PRIMARY KEY (id)
);</code>

The following query Will return all employees in descending order by column salary:

<code class="sql">SELECT name, salary
FROM employees
ORDER BY salary DESC;</code>

Notes:

• ##DESC Key Words can only be used in ORDER BY clauses.
You can sort multiple columns in descending order by separating the column names with commas and appending
• DESC after each column name. For example:

<code class="sql">SELECT name, salary
FROM employees
ORDER BY salary DESC, name DESC;</code>

This will sort the results by the

salary column in descending order, and if the salary are equal, then by the name# in descending order ## Column to sort the results.

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