/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

4 votes348 views6 answers
List all tables in postgres
SQL
0 vote316 views1 answer
Where name ends in SQL
SQL
0 vote314 views1 answer
Initcap in mysql
SQL
2 votes312 views1 answer
Oracle drop sequence if exists
SQL
0 vote298 views2 answers
How to see table associated with a schema in sql
SQL
0 vote309 views1 answer
Database get 10 user aleatory
SQL
1 vote321 views1 answer
Drop table if exists oracle
SQL
16 votes297 views3 answers
Order by sql query
SQL
1 vote322 views2 answers
Get table column names sql laravel
SQL
0 vote311 views1 answer
Mysql set column equal to another automatic
SQL