/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 vote191 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
4 votes180 views2 answers
Sql server date now
SQL
0 vote181 views1 answer
Mysql in clausule string array
SQL
0 vote196 views1 answer
Sqlite3 update select
SQL
2 votes203 views1 answer
Install postgresql centos 5
SQL
1 vote205 views1 answer
Sql list all procedures
SQL
0 vote181 views1 answer
Min and max salary and name in sql
SQL
0 vote232 views1 answer
Sql query for login with email or username
SQL
0 vote188 views1 answer
Object of class mysqli_result could not be converted to string
SQL
8 votes187 views1 answer
Sql remove leading spaces
SQL