/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 vote224 views1 answer
Oracle date winter time
SQL
0 vote207 views1 answer
Check if table exists oracle
SQL
0 vote218 views1 answer
Java check if something is in mysql table
SQL
7 votes235 views1 answer
Query postgres delete duplicates
SQL
2 votes221 views1 answer
SELECT INTO
SQL
-1 vote219 views1 answer
Adding a new table psql
SQL
25 votes222 views4 answers
Sqlserver add column
SQL
-1 vote223 views1 answer
How to create foreign key in sql server management studio
SQL
4 votes220 views1 answer
Mysql not equal
SQL
0 vote177 views1 answer
FindAllBy
SQL