ORDER BY ASC in SQL

ORDER BY ASC sorts the query results in ascending order (from smallest to largest).

? Syntax:

SELECT column1, column2, ...FROM table_nameORDER BY column_name ASC;

• ASC stands for ascending.

• This is the default sorting order in SQL, so ORDER BY column_name and ORDER BY column_name ASC are equivalent.

? Example:

Get all employees ordered by their names in ascending order (A to Z):

SELECT employee_name, salaryFROM employeesORDER BY employee_name ASC;

More example:

Order by salary ascending (lowest salary first):

SELECT employee_name, salaryFROM employeesORDER BY salary ASC;

Notes:

• You can use ASC with multiple columns:

ORDER BY department_id ASC, salary ASC;

• ASC is default, so you can omit it if you want.

Want me to explain ORDER BY DESC as well?