/SQL/How to sort names in alphabetical order in sql

How to sort names in alphabetical order in sql

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

1 vote309 views1 answer
Create sample data postgresql
SQL
1 vote331 views4 answers
Sql now
SQL
0 vote321 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
1 vote343 views4 answers
Psql check tables command
SQL
0 vote340 views3 answers
Database restoring error
SQL
2 votes308 views1 answer
Docker run postgres locally
SQL
0 vote302 views1 answer
How to get inserted id in sql server
SQL
0 vote314 views1 answer
Postgresql log
SQL
3 votes328 views2 answers
Oracle drop column
SQL
-1 vote339 views1 answer
Auto increment psql not primary key
SQL