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 vote370 views1 answer
Dual in db2
SQL
15 votes330 views2 answers
Sql order by multiple columns
SQL
2 votes379 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote355 views1 answer
Template MySQL Zabbix agent
SQL
5 votes368 views3 answers
Postgres show databases
SQL
1 vote336 views1 answer
Mysql month name extract
SQL
0 vote353 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote338 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote380 views1 answer
Mysql relationships between tables
SQL
0 vote356 views1 answer
Normalization in database
SQL