/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 vote317 views1 answer
Mysql connect command
SQL
15 votes323 views6 answers
Drop foreign key mysql
SQL
0 vote339 views1 answer
Like date sql server not working
SQL
0 vote400 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote336 views1 answer
Postgresql concat string with separator
SQL
0 vote345 views1 answer
Mysql Selected All Duplicate Rows
SQL
3 votes335 views2 answers
Oracle grants
SQL
5 votes289 views1 answer
Alter table default value mysql
SQL
0 vote339 views1 answer
Como hacer una consulta en sql
SQL
0 vote339 views1 answer
How to update sql server version
SQL