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 vote122 views1 answer
MYSQL stored procedure select from
SQL
0 vote125 views1 answer
Sub query in linq
SQL
0 vote101 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote105 views2 answers
Get top 1 row of each group
SQL
0 vote133 views1 answer
Gcloud sql list databases
SQL
0 vote139 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote130 views3 answers
Mysql regex replace
SQL
0 vote113 views1 answer
Psql initialization
SQL
5 votes122 views2 answers
Create function postgresql
SQL
0 vote112 views1 answer
How to print mysql query of codeigniter query builder
SQL