Oracle SQL

Sorting by Multiple Columns

Sorting by Multiple Columns
Avatar of shohal
Written by shohal

Sorting by Multiple Columns

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;

About the author

Avatar of shohal

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

Leave a Comment