/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

8 votes119 views3 answers
Connect python to mysql
SQL
0 vote130 views1 answer
Oracle show grants on table
SQL
-1 vote121 views2 answers
Postgresql get last 10 records
SQL
1 vote118 views1 answer
DATE_SUB postgres
SQL
0 vote122 views1 answer
Oracle get running queries
SQL
0 vote121 views1 answer
Mysql select inside sum
SQL
0 vote127 views1 answer
No suitable driver found for sqlite
SQL
-1 vote118 views1 answer
Ssql to lowercqse
SQL
0 vote137 views1 answer
Sqlalchemy case insensitive like
SQL
1 vote105 views1 answer
Sql alchemy with azuresql server
SQL