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

2 votes201 views3 answers
Sql truncate table
SQL
10 votes192 views4 answers
Mysql if else
SQL
0 vote186 views1 answer
Char vs varchar2 in sql
SQL
0 vote175 views1 answer
Composit key in sql
SQL
0 vote197 views1 answer
Insert data from stored procedure into table
SQL
1 vote187 views1 answer
Table infromation in sql server
SQL
14 votes180 views3 answers
Sql trim from string
SQL
0 vote182 views1 answer
Sql clear table
SQL
6 votes183 views2 answers
Difference between join vs union
SQL
0 vote191 views1 answer
Sqlite trim
SQL