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 vote185 views1 answer
Ansi sql count duplicate rows
SQL
3 votes161 views1 answer
Oracle limit user tablespace
SQL
3 votes164 views2 answers
Oracle grants
SQL
0 vote124 views1 answer
Check if has alpha characters sql
SQL
-2 votes195 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote176 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote169 views1 answer
Mysql_error replacement
SQL
2 votes162 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote128 views1 answer
Sqlalchemy existing database
SQL
3 votes184 views2 answers
Mysql select database
SQL