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

1 vote181 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote188 views1 answer
Kill slow queries mysql
SQL
0 vote159 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote166 views1 answer
Postrgres trunc
SQL
0 vote210 views1 answer
Where date in datetime mysql
SQL
0 vote184 views1 answer
Mariadb select limit offset
SQL
2 votes188 views2 answers
Laravel query builder toSql
SQL
49 votes285 views6 answers
Mysql add column to table
SQL
17 votes175 views6 answers
Mysql import sql file
SQL
14 votes190 views4 answers
Import database through command line
SQL