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 vote343 views1 answer
Raiserror nowait sql server
SQL
1 vote390 views1 answer
Sql select whole row max column
SQL
0 vote378 views1 answer
Oracle query archive mode
SQL
1 vote351 views1 answer
Alter table column size oracle
SQL
0 vote334 views1 answer
How to count null values in sql
SQL
6 votes362 views2 answers
Find mysql version linux
SQL
1 vote354 views1 answer
Sql delete row with auto increment
SQL
0 vote384 views2 answers
Soql last year
SQL
0 vote354 views1 answer
Commit transaction sql
SQL
3 votes340 views1 answer
Search for column name in psql
SQL