/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

14 votes308 views3 answers
Sql trim from string
SQL
0 vote303 views2 answers
How to find sql server agent jobs related to a database
SQL
10 votes288 views3 answers
Insert into auto increment mysql
SQL
25 votes322 views6 answers
Import mysql database command line
SQL
0 vote288 views1 answer
Select from 3 tables one is empty
SQL
0 vote318 views1 answer
Enable sql server full text indexing
SQL
0 vote495 views1 answer
Dublicate row sql
SQL
0 vote341 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote318 views1 answer
Oracle list partitions
SQL
0 vote282 views1 answer
Postgres add prefix to primary key
SQL