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

3 votes202 views3 answers
Postgresql random number
SQL
1 vote191 views1 answer
Add constraint sql
SQL
8 votes193 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote197 views1 answer
Import excel to sql
SQL
0 vote180 views1 answer
Python mysql query where
SQL
0 vote201 views1 answer
Sqlalchemy empty table
SQL
2 votes186 views1 answer
Mysql how to store lat,lng
SQL
1 vote202 views1 answer
Postgres convert date to string
SQL
0 vote218 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote206 views3 answers
Sql server import json
SQL