/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 vote214 views1 answer
Mysql login console
SQL
0 vote188 views1 answer
Mysqldump ignore table
SQL
4 votes198 views1 answer
Postgresql list sequences
SQL
2 votes188 views1 answer
Sqlite indexes
SQL
0 vote194 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote203 views1 answer
Order child below the parent in mysqli
SQL
0 vote186 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
1 vote320 views3 answers
Uninstall postgresql mac
SQL
1 vote189 views1 answer
Postgresql datetrunc too slow
SQL
2 votes188 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL