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

1 vote209 views1 answer
Install postgresql on raspberry pi
SQL
0 vote196 views1 answer
Mysql insert into select with recursive
SQL
0 vote199 views1 answer
Postgres call view
SQL
1 vote216 views1 answer
Update from select oracle
SQL
9 votes194 views2 answers
Sql limit order by
SQL
0 vote202 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote221 views1 answer
Sql get count without group by
SQL
0 vote228 views1 answer
Psql check table fields
SQL
0 vote214 views1 answer
Custom row number
SQL
22 votes270 views1 answer
Mysql workbench
SQL