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 vote215 views1 answer
Many rows to 1 string mysql
SQL
42 votes265 views6 answers
Rename table sql server
SQL
22 votes159 views2 answers
Mysql show all tables
SQL
1 vote180 views1 answer
Db.Database.SqlQuery
SQL
3 votes228 views2 answers
Find string in stored procedure sql server
SQL
0 vote221 views1 answer
Cahnge column name apex oracle
SQL
2 votes299 views2 answers
MySql FULL OUTER JOIN
SQL
3 votes200 views3 answers
Update con select postgresql
SQL
0 vote203 views1 answer
Finding leap year in sql
SQL
0 vote196 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL