/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

3 votes110 views2 answers
Sql asc
SQL
0 vote107 views1 answer
View t-sql mail configuration
SQL
2 votes107 views2 answers
Get all tables using like
SQL
0 vote103 views2 answers
SQL Server Standard
SQL
5 votes102 views1 answer
Ora-00054 find lock
SQL
0 vote136 views1 answer
Influxdb list all tags for a measurement
SQL
22 votes116 views3 answers
How to join three tables in sql using joins
SQL
5 votes114 views1 answer
Sort order on two columns sql
SQL
0 vote106 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote116 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL