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

3 votes103 views2 answers
Postgresql remove not null constraint
SQL
0 vote102 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote108 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote112 views1 answer
Error code 1292 mysql workbench
SQL
1 vote225 views3 answers
Sql subquery
SQL
4 votes108 views1 answer
SQL find text in SP
SQL
4 votes107 views2 answers
Oracle unlock user
SQL
0 vote106 views2 answers
Getting customers with no orders sql
SQL
0 vote109 views1 answer
How to check the port of mysql installation in mac
SQL
2 votes114 views3 answers
Current setting postgres timezone
SQL