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 vote205 views2 answers
How to see table associated with a schema in sql
SQL
0 vote222 views1 answer
Psql get table data types
SQL
0 vote227 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote244 views1 answer
Consecutive numbers sql
SQL
0 vote204 views1 answer
Oracle list dblink
SQL
1 vote222 views1 answer
Get table column names sql ssms
SQL
37 votes289 views6 answers
Mysql update
SQL
5 votes225 views6 answers
Sql foreign key
SQL
4 votes244 views6 answers
Select sql
SQL
1 vote212 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL