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

4 votes143 views1 answer
Oracle show errors
SQL
4 votes148 views1 answer
SQL find text in SP
SQL
0 vote140 views1 answer
Declarative base sqlalchemy
SQL
7 votes131 views6 answers
Group_concat mysql
SQL
0 vote147 views1 answer
Postgresql print sessions using the database
SQL
0 vote138 views1 answer
How to check replication lag in mySQL
SQL
0 vote134 views1 answer
Désinstaller postgresql linux
SQL
0 vote141 views2 answers
Sql query in dax power bi
SQL
8 votes152 views1 answer
Oracle search stored procedures for text
SQL
7 votes236 views2 answers
Sql empty table
SQL