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 vote225 views1 answer
Sql select sum group by id laravel
SQL
4 votes171 views3 answers
Oracle sql first day of quarter
SQL
1 vote399 views1 answer
How to make a select in sql
SQL
16 votes179 views6 answers
Mysql find and replace
SQL
1 vote184 views1 answer
Operator does not exist: integer = text
SQL
-1 vote278 views5 answers
Left join sql
SQL
4 votes169 views1 answer
Datepart postgres
SQL
0 vote220 views1 answer
Implode in sql query
SQL
0 vote201 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote218 views1 answer
Sql remove decimal places
SQL