/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 vote125 views1 answer
Restore backupfile discourse
SQL
5 votes122 views1 answer
Mysql select greater than yesterday
SQL
1 vote127 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote250 views1 answer
Android sqlite add column if not exists
SQL
0 vote134 views1 answer
Mysql beautifier terminla
SQL
6 votes157 views1 answer
To count number of rows in SQL table
SQL
19 votes135 views6 answers
Sql server drop table if exists
SQL
16 votes128 views3 answers
Delete row psql
SQL
1 vote125 views1 answer
Mamp mysql path mac
SQL
0 vote124 views1 answer
SQL loop with cursor
SQL