Microsoft Access SQL Keywords: DESC

	SQL Keywords: DESC

Description

The DESC keyword is used to sort the fields of a set. The DESC keyword is used in conjunction with the ORDER BY expression in a SELECT statement. The formula to use is:

SELECT What FROM WhatObject ORDER BY WhatField DESC;

Here is an example:

SELECT EmployeeNumber, FullName FROM Employees ORDER BY FullName DESC;

Here is another example:

SELECT * FROM Employees ORDER BY FullName DESC;