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

3 votes136 views1 answer
Créer une table sql
SQL
0 vote147 views1 answer
Sparql list all graphs
SQL
4 votes142 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
5 votes229 views1 answer
Oracle asynchronous procedure
SQL
0 vote171 views1 answer
Month mysql
SQL
0 vote146 views1 answer
Stratified sampling sql
SQL
0 vote132 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote193 views1 answer
Show mysql account privilleges
SQL
0 vote107 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote143 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL