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 votes159 views1 answer
Fk in insert mysql
SQL
1 vote173 views1 answer
Mysql how to truncate table with foreign keys
SQL
2 votes162 views1 answer
Mysql application.properties spring boot
SQL
5 votes161 views2 answers
Oracle tables with column name
SQL
2 votes155 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
25 votes154 views6 answers
Import mysql database command line
SQL
1 vote166 views1 answer
How to set up a trigger in sql
SQL
2 votes139 views2 answers
Get all columns from table sql
SQL
1 vote139 views1 answer
Jooq convert using gbk
SQL
16 votes170 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL