/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

19 votes172 views1 answer
Sqrt(-1)
SQL
0 vote203 views1 answer
Sql anywhere create procedure
SQL
0 vote194 views3 answers
Sql select statements
SQL
0 vote231 views1 answer
Generate sql from specific migration ef core
SQL
-1 vote204 views1 answer
Add column alter table default value
SQL
0 vote199 views1 answer
Search db for table name
SQL
1 vote220 views1 answer
Add many column to sap iq table
SQL
0 vote207 views2 answers
SQL BULK INSERT
SQL
0 vote221 views1 answer
Dockerfile example for Django
SQL
0 vote245 views1 answer
Snowflake drop column
SQL