/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 vote215 views1 answer
Foreign key constraint in ms sql
SQL
0 vote234 views3 answers
Create and attach user to a postgresql database
SQL
12 votes235 views2 answers
Delete entries in postgresql
SQL
1 vote216 views1 answer
Postgresql convert text to float
SQL
2 votes234 views1 answer
Oracle find unusable indexes
SQL
0 vote216 views1 answer
Postgresql get current user name
SQL
4 votes236 views1 answer
Postgresql create table with index
SQL
0 vote192 views1 answer
Sql select rows with simlar names
SQL
0 vote220 views1 answer
Java mysql date format
SQL
1 vote252 views1 answer
SQL Integer devision
SQL