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

6 votes132 views2 answers
Foreign key sqlite3 python
SQL
0 vote130 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
3 votes152 views3 answers
Order by postgres
SQL
0 vote121 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
3 votes139 views2 answers
Postgresql select all column names
SQL
0 vote124 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote125 views1 answer
Oracle list proxy users
SQL
0 vote133 views1 answer
Mysql update from select on same table
SQL
2 votes155 views3 answers
Postgres create view
SQL
0 vote127 views1 answer
Sql column as header
SQL