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

11 votes321 views2 answers
Oracle all source
SQL
0 vote342 views1 answer
Oracle remove line breaks
SQL
0 vote334 views1 answer
Sql value exists in column
SQL
1 vote329 views1 answer
Drop df constraint sql server
SQL
0 vote283 views1 answer
How to set field to null in sql
SQL
1 vote309 views2 answers
Difference between in and between in sql
SQL
3 votes355 views1 answer
Postgres select max value
SQL
0 vote365 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote322 views1 answer
Output to file mysql
SQL
0 vote302 views1 answer
Oracle sql date summer time
SQL