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 vote103 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote119 views1 answer
Coalesce for comma separated in sql server
SQL
8 votes132 views3 answers
SQL column name
SQL
0 vote121 views1 answer
Execut sql python
SQL
4 votes117 views1 answer
Oracle session date format
SQL
0 vote118 views1 answer
T-sql check if data exists
SQL
0 vote122 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote176 views1 answer
Postgres rename database
SQL
6 votes114 views5 answers
Get current date sql
SQL
0 vote118 views1 answer
Mysql calculated column
SQL