/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 vote111 views1 answer
Sql server beginning of month
SQL
0 vote96 views1 answer
Create function syntax sql server
SQL
0 vote112 views1 answer
Sql on-premises
SQL
0 vote101 views1 answer
Acutal month year
SQL
1 vote112 views1 answer
Postgres start database on linux
SQL
14 votes105 views5 answers
Set password for postgres user ubuntu
SQL
0 vote137 views1 answer
Sql date with year
SQL
0 vote121 views2 answers
Sql stored procedure for access frontend
SQL
11 votes99 views2 answers
Insert date sql
SQL
5 votes113 views1 answer
Oracle list days between two dates
SQL