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 vote399 views2 answers
Execute stored procedure without db set
SQL
0 vote342 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote370 views1 answer
Alasql delete column
SQL
9 votes342 views2 answers
Get first 3 letters in sql
SQL
6 votes344 views1 answer
How to count number of rows in sql
SQL
31 votes349 views3 answers
Sql count(*)
SQL
0 vote363 views1 answer
Mysql date minus 1 day
SQL
2 votes345 views1 answer
Apex date today add days
SQL
0 vote358 views1 answer
Postgresql comandos basicos
SQL
-1 vote386 views1 answer
Sql select data from one database and insert into a different database
SQL