/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 votes155 views3 answers
Connect python to mysql
SQL
0 vote147 views2 answers
Mysql two column combination unique
SQL
0 vote157 views1 answer
Mysql grant grant option
SQL
0 vote155 views1 answer
Get duplicate entry sql
SQL
0 vote158 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote151 views1 answer
Mysql match in serialized data
SQL
0 vote175 views1 answer
Postgres full text search example
SQL
0 vote147 views1 answer
Install mysql 8 linux
SQL
0 vote208 views1 answer
SQL Server Altering Column to be Unique
SQL
5 votes148 views1 answer
Update sql user password
SQL