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

Similar codes

1 vote312 views1 answer
Import sql file mysql commadn line
SQL
0 vote313 views1 answer
Kotlin sqlite delete row
SQL
0 vote315 views1 answer
Zerar auto increment mysql
SQL
12 votes316 views1 answer
Psql drop column
SQL
3 votes357 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote318 views1 answer
How get data from database if id not found then search another column
SQL
0 vote320 views1 answer
Order by in codeigniter query builder
SQL
4 votes302 views1 answer
Wilayah indonesia sql
SQL
0 vote296 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote312 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL