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 vote159 views1 answer
Mysql show category once count how many products
SQL
0 vote190 views2 answers
Call to undefined function mysql_query()
SQL
-1 vote186 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
4 votes164 views1 answer
SQL order random
SQL
0 vote119 views2 answers
Denormalization in sql
SQL
123 votes1.1K views5 answers
Sql where contains
SQL
0 vote168 views1 answer
Create a view in sqlite
SQL
11 votes159 views4 answers
MYSQL LOGIN
SQL
16 votes211 views3 answers
Order by sql query
SQL
1 vote172 views1 answer
Set mysql mode global query
SQL