/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

8 votes135 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote125 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote127 views1 answer
Inner joint
SQL
0 vote178 views1 answer
Creating sqeuence in oracle database
SQL
1 vote174 views1 answer
Insert pg result of select
SQL
1 vote171 views1 answer
Oracle drop chain step
SQL
37 votes173 views6 answers
Mysql update
SQL
0 vote139 views1 answer
How to login to mysql in homestead
SQL
22 votes166 views1 answer
Mysql workbench
SQL
5 votes135 views3 answers
Sql make column nullable
SQL