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 vote122 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
-1 vote171 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote125 views2 answers
Mysql trim spaces
SQL
0 vote138 views1 answer
Sql cmd no truncate
SQL
0 vote113 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote128 views1 answer
Sql check for null and empty string
SQL
0 vote116 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote112 views1 answer
Find wordpress version in database
SQL
0 vote209 views1 answer
Sql change a colum to unique
SQL
8 votes126 views1 answer
Oracle find text in functions
SQL