How to ascending order in sql

Ascending order and where in sql

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 ascending order in sql

SELECT *
FROM employees
ORDER BY employees.employee_id DESC ;

Similar codes

0 vote292 views1 answer
Look at running processes redshift
SQL
2 votes281 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote262 views1 answer
What is the difference between now() and current_date()?
SQL
5 votes243 views3 answers
Mysql check if null or empty string
SQL
0 vote264 views1 answer
How to declare variable date in mysql
SQL
0 vote222 views1 answer
Big query add table rows to another table
SQL
0 vote271 views1 answer
Psql list rules
SQL
25 votes255 views3 answers
Mysql command show tables
SQL
1 vote247 views1 answer
Delete row mssql
SQL
0 vote254 views1 answer
Sql get guid
SQL