How do you write a SQL Server query to return results i…
To query SQL Server in descending order, you can use the ORDER BY clause with the DESC keyword. Here is an example:
SELECT * FROM 表名
ORDER BY 列名 DESC;
In this case, the table name is the name of the table you want to query, and the column name is the name of the column you want to sort in descending order. The DESC keyword indicates sorting in descending order.
For example, to query the table named employees in descending order by the salary column, you can use the following statement:
SELECT * FROM employees
ORDER BY salary DESC;
This will retrieve all employee records and sort them in descending order based on salary.