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

2 votes224 views1 answer
Sqlite insert if not exists
SQL
0 vote215 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote236 views1 answer
Postgresql alter table sequence
SQL
0 vote192 views1 answer
What is the use of index in mysql table
SQL
0 vote189 views1 answer
Reading from right to left from string find first special characters in sql
SQL
1 vote185 views1 answer
Sql upsert
SQL
5 votes185 views1 answer
Postgresql functions
SQL
5 votes186 views1 answer
Mysql add user with all privileges
SQL
1 vote222 views1 answer
Postgresql create table with timestamp
SQL
1 vote196 views1 answer
Operator does not exist: integer = text
SQL