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 vote175 views1 answer
How to see logical reads in sql server
SQL
2 votes181 views1 answer
Sql server find columns list in tables
SQL
0 vote174 views2 answers
How to save result of sqlite query in a table
SQL
1 vote158 views1 answer
Delete triger pl pg sql
SQL
0 vote212 views1 answer
Sql query tags
SQL
0 vote190 views1 answer
No suitable driver found for sqlite
SQL
0 vote168 views1 answer
Add column to table with default value plsql
SQL
3 votes167 views1 answer
Sql multiple column index
SQL
3 votes178 views1 answer
How to check schema privileges in oracle
SQL
1 vote175 views2 answers
Mysql join two tables
SQL