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 vote198 views1 answer
How to print mysql query of codeigniter query builder
SQL
1 vote197 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote192 views1 answer
Sql inserted
SQL
0 vote219 views1 answer
How to combine first and last nae into one columb sql
SQL
11 votes193 views2 answers
Oracle all source
SQL
1 vote268 views1 answer
Drop column if exists sql server
SQL
0 vote261 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote211 views1 answer
Set engine to innodb
SQL
12 votes225 views1 answer
Create column sql server
SQL
0 vote267 views1 answer
SQL joins in python
SQL