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

0 vote283 views1 answer
T-SQL Retry (deadlock)
SQL
1 vote299 views3 answers
Java.sql.sqlexception: access denied for user
SQL
4 votes317 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
1 vote318 views2 answers
Extract weekday from date in sql
SQL
0 vote304 views1 answer
Mysql error 1452
SQL
8 votes299 views3 answers
Postgresql connection string c#
SQL
3 votes299 views2 answers
Oracle drop column
SQL
0 vote293 views1 answer
Match end of string regex sql
SQL
1 vote308 views1 answer
Search for replace in mysql
SQL
0 vote284 views1 answer
Sql remove last x char
SQL