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 vote146 views1 answer
Mssql + bit + in python orm
SQL
-1 vote167 views1 answer
Mysql faster insert
SQL
2 votes132 views3 answers
How to check current user in mySQL
SQL
0 vote131 views1 answer
With_for_update sqlalchemy
SQL
10 votes124 views4 answers
Primary key in sql
SQL
0 vote158 views1 answer
Python mysql executemany
SQL
0 vote119 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote142 views1 answer
Postgresql print sessions using the database
SQL
1 vote130 views1 answer
Mysql how to reset primary key
SQL
1 vote151 views2 answers
Drop table if exists test
SQL