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

3 votes287 views1 answer
Oracle nextval insert
SQL
0 vote231 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
21 votes237 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote234 views1 answer
Increase date by one day in sql oracle
SQL
1 vote237 views1 answer
SQL date part only of datetime
SQL
4 votes251 views2 answers
Installing sql on ubuntu
SQL
1 vote234 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote214 views1 answer
Create table employees oracle
SQL
0 vote282 views1 answer
Sql select without column name
SQL
31 votes248 views4 answers
Mysql grant execute
SQL