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 vote314 views1 answer
Sql server select record with max id
SQL
9 votes324 views5 answers
Laravel to sql
SQL
0 vote299 views1 answer
Sqlalchemy case insensitive like
SQL
51 votes408 views6 answers
Change column name sql
SQL
1 vote318 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
1 vote296 views1 answer
Oracle stop job
SQL
19 votes312 views6 answers
Sql server drop table if exists
SQL
1 vote317 views1 answer
Size of all tables in a schema oracle
SQL
0 vote294 views1 answer
Mariadb maximum left join
SQL
0 vote282 views1 answer
Opensuse status MySQL
SQL