Oracle SQL

Sorting by Multiple Columns

4 years ago

Written by shohal

For example, to sort person by their first names in ascending order and their last names in descending order, you use the following statement:


SELECT
	first_name,
	last_name
FROM
	person
ORDER BY
	first_name,
	last_name DESC;

SELECT

first_name,

last_name

FROM

person

ORDER BY

first_name,

last_name DESC;