/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

12 votes197 views6 answers
Distinct in sql server
SQL
1 vote158 views1 answer
Set statistics on in ssms
SQL
9 votes157 views3 answers
Show table columns mysql command line
SQL
0 vote176 views1 answer
Sql server alter table add column tinyint
SQL
0 vote173 views1 answer
Mysql docker image arjun
SQL
6 votes170 views1 answer
What is where clause in sql
SQL
0 vote171 views1 answer
Create table database in psql
SQL
0 vote159 views3 answers
Sql all columns
SQL
1 vote210 views1 answer
Sql select sum group by id laravel
SQL
0 vote162 views1 answer
Sqlite closes value
SQL