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 vote114 views1 answer
Sql server list user permissions
SQL
23 votes123 views4 answers
Sql server substring
SQL
0 vote115 views1 answer
Sql server bool select
SQL
0 vote137 views1 answer
Select * where id = 1,2,3
SQL
0 vote119 views1 answer
Sql create table with datetime automatically
SQL
13 votes129 views5 answers
Sql default
SQL
0 vote111 views1 answer
Declare date variable sql
SQL
2 votes112 views1 answer
Sql server find table name
SQL
5 votes127 views1 answer
Oracle sysdate - 1 month
SQL
0 vote115 views1 answer
Turnicate in mysql
SQL