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 vote178 views2 answers
Sql 2 way of select unique
SQL
0 vote159 views2 answers
Sql count number of rows after group by
SQL
2 votes172 views1 answer
Sqlite indexes
SQL
4 votes163 views2 answers
Linq join
SQL
5 votes170 views3 answers
Sql make column nullable
SQL
2 votes171 views1 answer
Oracle to_char number format percentage
SQL
0 vote225 views1 answer
Postgres dump sql insert
SQL
10 votes169 views3 answers
Insert into auto increment mysql
SQL
1 vote214 views1 answer
Is sql fast
SQL
0 vote171 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL