/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 vote185 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote197 views1 answer
Search for tables with name postgresql
SQL
0 vote193 views2 answers
Sql last updated
SQL
0 vote234 views1 answer
Plsql check how much space all databases are consuming
SQL
6 votes210 views3 answers
What is where in sql
SQL
0 vote177 views1 answer
View acl table oracle
SQL
17 votes197 views2 answers
T_sql contains
SQL
0 vote191 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
1 vote304 views1 answer
Aqua Data studio postgresql ssl
SQL
3 votes183 views2 answers
Postgres inner join vs join
SQL