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 vote320 views1 answer
Add sqlite3 in lumen
SQL
1 vote330 views1 answer
Increase existing date in sql oracle
SQL
0 vote379 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote369 views1 answer
How to find sql server installation folder
SQL
1 vote360 views5 answers
Postgresql difference between two dates in days
SQL
0 vote369 views1 answer
Distance calculator from lat long sql query
SQL
0 vote364 views1 answer
Sql date with year
SQL
0 vote348 views1 answer
Get the next column of a table in mysql
SQL
1 vote324 views1 answer
Set statistics on in ssms
SQL
0 vote329 views1 answer
Get cpu details sql
SQL