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

3 votes183 views1 answer
Set default today mysql
SQL
0 vote182 views1 answer
Sql delete where x or y or z
SQL
0 vote175 views1 answer
Sql select duplicates based on two columns
SQL
0 vote187 views1 answer
Like date sql server not working
SQL
13 votes187 views2 answers
Sql online compiler
SQL
1 vote178 views1 answer
Woocommerce mysql price table
SQL
0 vote174 views1 answer
Sql create table with datetime automatically
SQL
0 vote183 views1 answer
Select multiple row from primary key sql
SQL
18 votes169 views3 answers
Mysql current date
SQL
1 vote198 views1 answer
Select users with same username
SQL