/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

0 vote281 views1 answer
Ms sql print more than 1 variable
SQL
1 vote322 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote300 views1 answer
Plsql trigger insert update
SQL
15 votes365 views6 answers
Laravel db transaction
SQL
0 vote360 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote408 views1 answer
ALV GRID events
SQL
17 votes332 views6 answers
Sql select distinct
SQL
1 vote295 views1 answer
Alter user mysql native password
SQL
0 vote333 views1 answer
Oracle sql procedure return value
SQL
-1 vote349 views3 answers
Compute age mysql
SQL