/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 vote182 views1 answer
Mysql error 1452
SQL
1 vote206 views2 answers
How to search date in sql query
SQL
0 vote188 views1 answer
Get yesterday date ISO in psql
SQL
0 vote269 views1 answer
Restart serial number for postgres
SQL
0 vote190 views1 answer
Hw to delete a procedure in pl sql
SQL
2 votes263 views1 answer
How to check grants on a package in oracle
SQL
12 votes206 views4 answers
Mysql version
SQL
0 vote189 views1 answer
Create a table from one field of another table
SQL
0 vote193 views1 answer
Mysql subdate
SQL
0 vote204 views1 answer
Compare field sql server
SQL