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

7 votes282 views1 answer
Append column sql
SQL
5 votes304 views1 answer
Oracle sysdate - 1 month
SQL
-1 vote313 views1 answer
Auto increment psql not primary key
SQL
0 vote277 views1 answer
Resulting Query
SQL
1 vote283 views1 answer
Mysql random limit 1
SQL
0 vote292 views1 answer
Sequelize postgresql schema
SQL
0 vote332 views1 answer
C# sql transaction multiple connections
SQL
-1 vote271 views2 answers
How to display top 50 rows?
SQL
0 vote297 views1 answer
Selecting Data in SQL - Select Data
SQL
1 vote300 views1 answer
Blob datatype in mysql
SQL