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 vote215 views1 answer
Sqlite woth cmake
SQL
0 vote183 views1 answer
Group_concat only returns one row
SQL
0 vote195 views2 answers
Get top 1 row of each group
SQL
0 vote188 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote186 views1 answer
Sql put two columns into one
SQL
0 vote171 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote199 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
1 vote200 views1 answer
Cross schema query oracle 2 users
SQL
5 votes199 views5 answers
Sqlite install python
SQL
0 vote202 views2 answers
How to relationship query two different tables in MySQL
SQL