/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 vote368 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote360 views1 answer
Mysql insert into select transaction c#
SQL
0 vote384 views1 answer
View psql output in horizontal scrolling
SQL
10 votes345 views2 answers
Reset mysql root password mac
SQL
1 vote345 views1 answer
Get last week data in mysql
SQL
0 vote322 views1 answer
Jooq finding lastest value in table
SQL
0 vote391 views1 answer
Contraint default SQL
SQL
1 vote367 views1 answer
Sql dcl
SQL
7 votes329 views4 answers
How to reset the identity column in sql server
SQL
0 vote392 views1 answer
Sql select sum group by id laravel join
SQL