/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

2 votes184 views2 answers
Mysql bidirectional composite primary key
SQL
45 votes197 views5 answers
Grant all privileges mysql
SQL
0 vote164 views4 answers
Change schema in sql server
SQL
0 vote184 views1 answer
Changing name of column and datatype in sql
SQL
0 vote195 views1 answer
Hour and minute between two datatime sql
SQL
4 votes189 views1 answer
Group by mysql and concatenate string
SQL
7 votes178 views3 answers
Python and mysql connectivity
SQL
1 vote192 views2 answers
Postgresql check privileges on schema
SQL
0 vote166 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
17 votes191 views4 answers
Postgres list users
SQL