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

1 vote217 views1 answer
Increasing font and zooming in mysql workbench
SQL
2 votes180 views2 answers
Mysql all columns
SQL
8 votes254 views2 answers
Python simple connect to mysql
SQL
20 votes199 views3 answers
How to open postgresql in mac
SQL
8 votes191 views3 answers
Connect python to mysql
SQL
0 vote196 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
4 votes183 views1 answer
Postgresql show current database
SQL
4 votes189 views4 answers
Start mysql
SQL
0 vote198 views1 answer
Describe in sqlite3
SQL
0 vote199 views1 answer
Mysql regex select
SQL