/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

11 votes276 views2 answers
MySQL DISTINCT
SQL
0 vote309 views1 answer
C# execute transact sql
SQL
1 vote286 views1 answer
Pagination sql
SQL
1 vote271 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote320 views1 answer
Transaction and commit trong sql server
SQL
0 vote309 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote309 views1 answer
Check user sql password from command line
SQL
0 vote286 views3 answers
Postgresql allow remote connections
SQL
0 vote286 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
2 votes312 views1 answer
Oracle to_char number format percentage
SQL