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 vote236 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote210 views1 answer
Sql select rows with simlar names
SQL
31 votes272 views4 answers
Mysql grant execute
SQL
3 votes260 views1 answer
Query less than datetime sql
SQL
4 votes330 views2 answers
Delete all table oracle
SQL
8 votes310 views3 answers
Find table for column name in sql
SQL
3 votes312 views1 answer
Oracle list invalid password logon denied
SQL
0 vote241 views1 answer
Login failed for login due to trigger execution
SQL
3 votes263 views2 answers
How to modify rows in SQL Server
SQL
0 vote257 views1 answer
How to combine rows in sql server procedure
SQL