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

1 vote368 views1 answer
Delete dublicate rows sql
SQL
5 votes309 views1 answer
How to use rank function in sql
SQL
11 votes342 views1 answer
Ddl view
SQL
0 vote307 views1 answer
C# datetime to sql server datetime
SQL
0 vote306 views2 answers
Create new table plsql
SQL
1 vote329 views1 answer
Postgres check blocking
SQL
4 votes294 views1 answer
Update table from another table oracle
SQL
9 votes341 views2 answers
SELECT User,Host FROM mysql.user;
SQL
3 votes304 views1 answer
Oracle rollback
SQL
2 votes290 views2 answers
Insert all in sql
SQL