sql sort list alphabetically code example

Example 1: how to sort names in alphabetical order in sql

SELECT id,  
    first_name,
    last_name, 
  FROM customer
  ORDER BY last_name ASC;

Example 2: descending order sql

SELECT *
FROM employees
ORDER BY employees.employee_id DESC ;
·        Ascending ( ASC)
·        Descending ( DESC)