/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

1 vote270 views2 answers
How to search date in sql query
SQL
0 vote258 views1 answer
Sql find table by name
SQL
1 vote265 views1 answer
Tsql create unique index composite
SQL
1 vote256 views1 answer
Sql select where id not exists in another table
SQL
0 vote263 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote273 views1 answer
Get who is hired in month in sql
SQL
0 vote252 views1 answer
Json not contains mysql
SQL
4 votes252 views1 answer
To date oracle with time
SQL
0 vote294 views1 answer
Add new column in sql with foreign key
SQL
12 votes273 views2 answers
Find duplicates mysql column
SQL