/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 vote241 views1 answer
Oracle flush Shared Pool
SQL
2 votes235 views1 answer
Sql select min value from multiple columns
SQL
0 vote259 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote237 views1 answer
Postgres format date in select
SQL
0 vote262 views1 answer
Connecting to my cloud sql server with c#
SQL
2 votes244 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote307 views1 answer
How to add auto increment primary key
SQL
1 vote244 views1 answer
How to check the mysql version mac
SQL
0 vote251 views1 answer
Max mysql
SQL
0 vote264 views1 answer
Alter table change default
SQL