/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 vote192 views1 answer
IIF
SQL
0 vote258 views1 answer
Python mysql executemany
SQL
0 vote225 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote335 views3 answers
Osx stop mysql service
SQL
0 vote198 views1 answer
Oracle sql log to console
SQL
31 votes283 views4 answers
Mysql grant execute
SQL
0 vote287 views1 answer
Sqlite display headers on columns
SQL
13 votes234 views2 answers
Oracle inner join
SQL
10 votes208 views1 answer
User_dependencies
SQL
0 vote249 views1 answer
Selecting Multiple Columns in SQL
SQL