/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 vote152 views1 answer
Guid string to binary better
SQL
3 votes145 views2 answers
Plsql print
SQL
0 vote152 views1 answer
Default value false mysql
SQL
-1 vote149 views3 answers
Update mongodb version ubuntu
SQL
0 vote152 views1 answer
Creation d'un trigger sql
SQL
1 vote158 views1 answer
How to truncate a table in databse
SQL
0 vote140 views1 answer
Group_concat only returns one row
SQL
2 votes178 views1 answer
Mysql shell insert into
SQL
0 vote146 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote154 views1 answer
Oracle nvl2
SQL