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

12 votes147 views4 answers
Mysql version query
SQL
3 votes155 views1 answer
Oracle user quota on tablespace
SQL
24 votes146 views4 answers
Postgres delete database
SQL
0 vote143 views1 answer
Load utilities in sql server
SQL
0 vote144 views1 answer
How much table store postgres
SQL
1 vote145 views4 answers
Fatal database postgres does not exist
SQL
10 votes146 views5 answers
Between keyword in sql
SQL
2 votes160 views3 answers
Sql interview query questions
SQL
16 votes152 views3 answers
Jwt secret key generator laravel
SQL
4 votes153 views3 answers
Sql drop primary key
SQL