/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 vote183 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
10 votes166 views1 answer
How to import database in mysql by cmd
SQL
0 vote193 views1 answer
Php select data from mysql database without column name
SQL
0 vote180 views1 answer
Sql track modification
SQL
1 vote180 views1 answer
Mysql change root mysql_native_password
SQL
0 vote187 views1 answer
Char vs varchar2 in sql
SQL
1 vote194 views1 answer
Top 10 rows in mysql
SQL
1 vote181 views1 answer
Mysql size int
SQL
0 vote168 views1 answer
Sql from null to not null
SQL
1 vote182 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL