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 vote200 views1 answer
How to run parallel queries in sql server with entity framework
SQL
5 votes175 views1 answer
Mysql get last day of month
SQL
0 vote187 views1 answer
Oracle webcenter content search enginer
SQL
0 vote270 views1 answer
Mariadb date equals to current_date plus days
SQL
2 votes191 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote310 views1 answer
Primary key reset in SQL database
SQL
0 vote264 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote188 views1 answer
Mysql show queries running
SQL
0 vote178 views1 answer
Sql server split string and insert into table select
SQL
1 vote191 views1 answer
Psql lst trigger
SQL