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

5 votes236 views4 answers
Traduction
SQL
0 vote250 views1 answer
Mysql date without time
SQL
0 vote235 views1 answer
Psql show db
SQL
0 vote215 views1 answer
Safe mysql
SQL
0 vote182 views1 answer
Create duplicate table in postgresql
SQL
25 votes231 views5 answers
Date in mysql
SQL
0 vote213 views1 answer
Mysql add to value
SQL
0 vote228 views1 answer
SQL Server rename foreign key constraint
SQL
1 vote233 views1 answer
What is a Database?
SQL
0 vote212 views1 answer
Oracle exchange subpartition
SQL