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 vote333 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote343 views1 answer
Tsql default value when no value returned by query
SQL
0 vote347 views1 answer
Oracle sql drop table
SQL
0 vote440 views1 answer
Plpgsql create function
SQL
0 vote360 views1 answer
OFFSET consulta mysql
SQL
0 vote385 views1 answer
Sql remove non numeric characters
SQL
6 votes340 views1 answer
Allsource oracle
SQL
0 vote359 views1 answer
No query unable to fetch row sqlite
SQL
-1 vote316 views2 answers
Sql query examples
SQL
1 vote370 views2 answers
Mysql switch case
SQL