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 vote317 views1 answer
Mysql terminal list table
SQL
17 votes326 views6 answers
Sql select distinct
SQL
0 vote390 views1 answer
Download sql file of countries names
SQL
3 votes321 views2 answers
How to View column names of a table in SQL
SQL
0 vote351 views1 answer
Postgres regex word boundary
SQL
1 vote348 views2 answers
Find nth highest salary of an employee
SQL
3 votes332 views2 answers
Brew start mysql
SQL
1 vote336 views3 answers
How to get date in sql
SQL
0 vote328 views1 answer
Sql server datetime to string
SQL
8 votes340 views1 answer
Script to add datafile to tablespace
SQL