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

-1 vote266 views1 answer
Ssms connect with connection string
SQL
2 votes278 views2 answers
Mysql user access to database
SQL
1 vote264 views1 answer
How to truncate a table in databse
SQL
2 votes262 views2 answers
Install sqlalchemy
SQL
5 votes273 views3 answers
MySql get fields of table
SQL
0 vote275 views1 answer
Create bdd mysql
SQL
0 vote256 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote278 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote293 views1 answer
The package java.sql is not accessible
SQL
0 vote308 views1 answer
Pgadmin check database
SQL