Order by sql query

Order by sql

//this_for_descending_order.. 
 SELECT * FROM TableName ORDER BY columnName DESC;
 // this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;

Sort by 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

Order by sql query

//for accending order
SELECT * FROM TableName ORDER BY ColumnName;

//for descending order
SELECT * FROM TableName ORDER BY ColumnName DESC;

Similar codes

1 vote105 views1 answer
Oracle difference between two dates in years
SQL
0 vote99 views1 answer
How to stop all connections to a psql 12 database?
SQL
6 votes114 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote102 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote109 views2 answers
Pl sql auto increment
SQL
0 vote123 views1 answer
Mariadb disable foreign key checks
SQL
0 vote108 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote148 views2 answers
Sql split string by space
SQL
-2 votes118 views2 answers
Union all in sql
SQL
1 vote215 views1 answer
Sql check roles
SQL