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

15 votes202 views3 answers
Find duplicate keys in mysql
SQL
1 vote200 views1 answer
Sql view where tables have same column name combine results
SQL
5 votes183 views1 answer
Sql first day of current year
SQL
0 vote192 views1 answer
How to print records of employees hired in particular month in oracle
SQL
2 votes216 views3 answers
Postgres json to string
SQL
0 vote183 views4 answers
How to drop all tables in sql
SQL
0 vote186 views1 answer
Download mysql database to excel in android studio
SQL
1 vote201 views2 answers
Login to mysql
SQL
3 votes189 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote234 views1 answer
How to get table id sequence postgres
SQL