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 vote322 views1 answer
Delete data from database sqlite android
SQL
8 votes310 views1 answer
Oracle search source code
SQL
33 votes377 views6 answers
Sql delete
SQL
0 vote354 views1 answer
Space not removing from column in sql
SQL
1 vote302 views3 answers
Postgresql connect to database
SQL
2 votes309 views3 answers
3 days back in sql server
SQL
0 vote295 views1 answer
Import mysql'
SQL
0 vote319 views1 answer
On sql table data exists
SQL
5 votes282 views1 answer
Mongodb vs
SQL
2 votes331 views1 answer
Mysql application.properties spring boot
SQL