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

2 votes156 views2 answers
Postgres select duplicate columns
SQL
0 vote160 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote147 views1 answer
Sql check for null and empty string
SQL
0 vote156 views2 answers
Sql use not in
SQL
1 vote160 views2 answers
Test sqlsrv connection
SQL
0 vote174 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote191 views1 answer
Sparql if bound query
SQL
5 votes124 views1 answer
Alter table default value mysql
SQL
0 vote188 views2 answers
Mysql where in maintain order group_concat
SQL
12 votes209 views2 answers
Update column data type postgres
SQL