/SQL/How to sort names in alphabetical order in sql

How to sort names in alphabetical order in sql

Sql order by alphabetical

SELECT * FROM table_name ORDER BY col1 ASC;				-- ASCending is default
SELECT * FROM table_name ORDER BY col1 DESC;			-- DESCending
SELECT * FROM table_name ORDER BY col1 DESC, col2;		-- col1 DESC then col2 ASC

How to sort names in alphabetical order in sql

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

Source: learnsql.com

Similar codes

6 votes301 views1 answer
Oracle trigger after logon on database
SQL
0 vote277 views1 answer
Mysql shell ERROR: Not connected.
SQL
8 votes289 views1 answer
Oracle add datafile to tablespace
SQL
3 votes263 views1 answer
Oracle apex warning message
SQL
2 votes254 views1 answer
Sql select min value from multiple columns
SQL
0 vote263 views1 answer
Postgresql regular expression special characters
SQL
0 vote337 views1 answer
ALV GRID events
SQL
0 vote279 views2 answers
How to set global time_zone in mysql
SQL
0 vote293 views1 answer
Compare subqueries oracle
SQL
0 vote289 views1 answer
No query unable to fetch row sqlite
SQL