/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 vote179 views1 answer
Grant access on table in oracle
SQL
0 vote188 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
-1 vote212 views1 answer
Mysql faster insert
SQL
0 vote181 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote184 views1 answer
Sql select most frequent value in column
SQL
0 vote207 views1 answer
Sqlcmd no headers
SQL
1 vote182 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote178 views1 answer
Optimize sql query
SQL
13 votes192 views1 answer
Select count of distinct values sql
SQL
13 votes240 views3 answers
Mysqldump structure only
SQL