Order by postgres

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

Order by postgres

SELECT
	*
FROM
	users
ORDER BY
	country;
 
------ Bu yerda davlatlar bo'ycha Alifbo bo'yicha saralab beradi.

Similar codes

0 vote163 views1 answer
Start stop mysql linux
SQL
0 vote126 views1 answer
Output table plsql
SQL
0 vote149 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote126 views1 answer
How to check which sp is running in sql server
SQL
0 vote156 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote199 views1 answer
Mysql collation portugues brasil
SQL
0 vote135 views1 answer
Mysql identified by syntax error
SQL
15 votes136 views4 answers
Mysql where value is null
SQL
0 vote139 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
1 vote150 views1 answer
Postgres see sequence current state
SQL