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

0 vote126 views1 answer
Intellij mysql set timezone
SQL
17 votes132 views4 answers
Postgres list users
SQL
-1 vote137 views8 answers
Sql to c# linq converter online
SQL
0 vote150 views1 answer
SQL check if record exist
SQL
1 vote129 views1 answer
Select not matching data from two tables
SQL
1 vote144 views1 answer
Postgres select as csv
SQL
0 vote121 views2 answers
Get all index postgres
SQL
16 votes124 views6 answers
Mysql find and replace
SQL
1 vote130 views1 answer
Oracle update with sequence
SQL
18 votes127 views4 answers
Uninstall mysql on ubuntu
SQL