/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

9 votes354 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote376 views1 answer
Sql script to remove default from column
SQL
0 vote322 views1 answer
How to export table data from mysql table in sql format
SQL
5 votes344 views1 answer
Sql use database
SQL
0 vote397 views1 answer
Stratified sampling sql
SQL
0 vote337 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote324 views2 answers
Which MySQL statement is used to delete data from a database
SQL
3 votes324 views2 answers
Mysql time
SQL
4 votes324 views1 answer
Oracle show error line number
SQL
3 votes361 views4 answers
Order by desc postgres
SQL