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 vote228 views1 answer
Postgresql if 0 then 1
SQL
5 votes199 views1 answer
Oracle asynchronous update
SQL
0 vote219 views2 answers
Clauses in mysql
SQL
0 vote220 views1 answer
"Hello User Name"
SQL
2 votes184 views1 answer
Cast string to datetime mysql
SQL
1 vote189 views2 answers
Begin transaction in sql
SQL
0 vote185 views2 answers
Tsql row number
SQL
5 votes254 views1 answer
Mysql last day of next month
SQL
2 votes189 views1 answer
Q operator in sql
SQL
0 vote212 views1 answer
How to print sql query
SQL