/SQL/How to sort names in alphabetical order in sql

How to sort names in alphabetical order in sql

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 vote133 views1 answer
What is the essence of SQL?
SQL
25 votes155 views6 answers
How to change column name in mysql
SQL
1 vote147 views1 answer
Mysql return if it contains
SQL
2 votes136 views2 answers
Mysql on duplicate key ignore
SQL
0 vote128 views1 answer
Mysql percentage of total
SQL
21 votes142 views5 answers
Oracle all tables
SQL
5 votes144 views3 answers
Mysql update field from one table to another
SQL
0 vote163 views1 answer
Sql basic commands
SQL
1 vote165 views1 answer
Create new index takes long time postgresql
SQL
2 votes171 views2 answers
Postgres set user as superuser
SQL