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 vote200 views1 answer
Query to insert image
SQL
10 votes205 views2 answers
Rtrim sql
SQL
1 vote194 views1 answer
Set statiscis on in sql server
SQL
-1 vote209 views1 answer
Su: Authentication failure mysql
SQL
13 votes199 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote231 views1 answer
Sql row having max
SQL
0 vote215 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote200 views1 answer
Minus equivalent in my sql
SQL
2 votes241 views1 answer
Postgresql group by month and year
SQL
0 vote227 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL