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 vote143 views3 answers
Postgresql allow remote connections
SQL
1 vote149 views4 answers
Aggregate function in sql
SQL
0 vote207 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote216 views1 answer
Mssql unique key accept nulls
SQL
0 vote157 views1 answer
Sqlite3 not commit
SQL
0 vote176 views1 answer
Psql create usr
SQL
4 votes144 views2 answers
Sql offset
SQL
2 votes188 views2 answers
Mysql date range
SQL
20 votes150 views6 answers
Creating a table in sql
SQL
0 vote136 views1 answer
Oracle dynamic select into
SQL