Order by postgresql

Order by desc postgres

SELECT TOP 1
	*
FROM
	users
ORDER BY
	id desc;

Order by postgresql

        
            
        
     SELECT
	select_list
FROM
	table_name
ORDER BY
	sort_expression1 [ASC | DESC],
        ...
	sort_expressionN [ASC | DESC];Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote286 views1 answer
Sql today at midnight
SQL
0 vote248 views1 answer
How to insert same table data using mysql query
SQL
1 vote273 views2 answers
Postgresql remote connect
SQL
0 vote260 views1 answer
Mysql terminal list table
SQL
0 vote270 views1 answer
MySQL get all previous date record
SQL
2 votes330 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote256 views1 answer
Storing RGBA in mysql db
SQL
0 vote268 views1 answer
Sql count more than 1
SQL
0 vote277 views1 answer
How to set sql_mode for a query in CI model
SQL
-1 vote257 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL