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 vote141 views1 answer
Mysql connect bash
SQL
0 vote147 views1 answer
Oracle sql date winter time
SQL
3 votes151 views1 answer
Oracle undo tablespace schema
SQL
4 votes173 views1 answer
Alter session set nls_date_format
SQL
0 vote149 views1 answer
Query only first letter string
SQL
0 vote152 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
3 votes153 views2 answers
Postgresql select all column names
SQL
31 votes149 views4 answers
How to get duplicate records with multiple field in sql
SQL
6 votes137 views2 answers
Mysql get yesterday
SQL
0 vote152 views1 answer
Select multiple row from primary key sql
SQL