/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

23 votes239 views6 answers
Create table sql server
SQL
1 vote230 views1 answer
Float precision in psql
SQL
4 votes224 views1 answer
Mysql timestamp in laravel migration
SQL
3 votes240 views5 answers
Duplicate table sql
SQL
0 vote212 views1 answer
How to count null values in sql
SQL
0 vote237 views1 answer
OFFSET consulta mysql
SQL
1 vote240 views1 answer
Oracle grant select on schema
SQL
0 vote222 views1 answer
Oracle create table auto generated primary key
SQL
2 votes205 views1 answer
Sql find missing values between two tables
SQL
4 votes233 views1 answer
For loop postgresql
SQL