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 vote331 views1 answer
Sql server create constraint
SQL
0 vote343 views1 answer
Set Mamp mysql globally
SQL
1 vote338 views1 answer
Pgsql sum switch case
SQL
3 votes356 views2 answers
Oracle sql first day of month
SQL
1 vote336 views1 answer
Oracle avg
SQL
0 vote328 views1 answer
Permission denied postgres \copy csv command line
SQL
40 votes423 views4 answers
PostgreSQL add column
SQL
0 vote404 views1 answer
How to check foreign key constraint in sql
SQL
1 vote289 views1 answer
Metada in sql
SQL
0 vote312 views1 answer
Delete double on SQL with multiple primary keys
SQL