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

2 votes204 views2 answers
Convert_tz mysql
SQL
1 vote254 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
7 votes172 views1 answer
Set sequence value oracle
SQL
0 vote161 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote126 views1 answer
Sql count how many times a value appears
SQL
2 votes171 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote196 views1 answer
Database db connection string format
SQL
2 votes169 views1 answer
Delete all value query
SQL
0 vote204 views1 answer
Compare strings lexicographically in sql
SQL
1 vote160 views1 answer
Sql server find tables referenced foreign key
SQL