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 vote133 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote138 views1 answer
Sql server today minus n
SQL
1 vote120 views1 answer
Mysql batch insert
SQL
1 vote118 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
2 votes129 views1 answer
Change primary key sql
SQL
4 votes152 views1 answer
Is there any command to change postgres password
SQL
0 vote121 views1 answer
Check duplicate values plsql
SQL
0 vote112 views1 answer
Duplicate foreign key constraint name
SQL
0 vote132 views1 answer
Ajouter une clé etrangere mysql
SQL
5 votes121 views1 answer
Sqlite alter table add column
SQL