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 vote291 views1 answer
Extract Data from SQL Server into XML Format
SQL
6 votes312 views3 answers
How to delete table sqlite
SQL
0 vote294 views1 answer
Difference between min and max date sql
SQL
0 vote273 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote292 views1 answer
Mysql loop through databases and execute query
SQL
0 vote280 views4 answers
Database stuck at restoring state
SQL
0 vote251 views1 answer
Grant owner postgresql
SQL
9 votes291 views2 answers
Sql server check table exists
SQL
2 votes275 views1 answer
Oracle log files
SQL
0 vote300 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL