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

3 votes125 views2 answers
Postgres inner join vs join
SQL
13 votes118 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote157 views1 answer
Many rows to 1 string mysql
SQL
2 votes141 views2 answers
Mysql does sentence contain word
SQL
0 vote133 views1 answer
Mysql add text to existing field
SQL
0 vote138 views1 answer
Postgresql create query
SQL
2 votes155 views4 answers
List databases in sql server
SQL
0 vote117 views1 answer
Mysql workbench indent formatting
SQL
0 vote135 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote133 views1 answer
Type int in mysql maxlenght
SQL