/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

28 votes148 views4 answers
Delete database mysql
SQL
0 vote125 views1 answer
Login phpmyadmin without password
SQL
0 vote223 views1 answer
Mysql disable triggers
SQL
0 vote147 views1 answer
Get current date data in mysql
SQL
0 vote186 views1 answer
Sql cheetsheet
SQL
0 vote161 views1 answer
Search In the Data using ObjectName
SQL
0 vote144 views4 answers
Mysql count table rows
SQL
3 votes158 views2 answers
Install mysql powershell
SQL
0 vote177 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote159 views1 answer
Mysql type for large numbers with many decimal
SQL