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 votes209 views1 answer
Insert into table from another table mysql
SQL
0 vote221 views1 answer
Pip install mysqlclient error
SQL
0 vote228 views5 answers
Sql table intermédiaire
SQL
1 vote173 views1 answer
Convert money to varchar sql server
SQL
0 vote184 views1 answer
Mysql convert column to uppercase
SQL
1 vote245 views1 answer
How to lock table in mysql
SQL
0 vote246 views1 answer
Get who is hired in february in sql
SQL
0 vote225 views1 answer
Mysql wsrep ls
SQL
0 vote231 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote240 views1 answer
Mysql dump for selected row
SQL