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

8 votes284 views3 answers
Postgresql connection string c#
SQL
3 votes309 views2 answers
Check data in table mysql
SQL
0 vote270 views1 answer
Get last updated row sql server
SQL
0 vote279 views4 answers
Change schema in sql server
SQL
1 vote277 views1 answer
Mysql dump specific tables
SQL
13 votes318 views3 answers
Mysqldump structure only
SQL
4 votes271 views2 answers
Postgresql default value
SQL
0 vote275 views1 answer
Drop all tables db2
SQL
6 votes266 views1 answer
Oracle rank() over (partition)
SQL
0 vote251 views1 answer
Suse start MySQL
SQL