/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

5 votes350 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote358 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote332 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote314 views1 answer
How to set field to null in sql
SQL
0 vote370 views2 answers
Update all columns in one update
SQL
19 votes386 views6 answers
Mysql if null
SQL
0 vote376 views1 answer
The package java.sql is not accessible
SQL
12 votes351 views2 answers
Delete entries in postgresql
SQL
17 votes330 views2 answers
How to assign date field for table in mysql
SQL
1 vote382 views1 answer
Find a column in all tables postgres
SQL