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 vote180 views1 answer
Openquery update linked server
SQL
0 vote155 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote175 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote184 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote172 views1 answer
Syntax for changing column size in mysql
SQL
0 vote153 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote191 views1 answer
Mariadb get column names from table
SQL
1 vote165 views1 answer
Psql datetime grather than
SQL
7 votes160 views2 answers
Create index mysql
SQL
2 votes194 views2 answers
Sqlalchemy return id after insert
SQL