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

0 vote111 views1 answer
Sql revert migration
SQL
6 votes131 views2 answers
Oracle trigger
SQL
0 vote116 views1 answer
Mysql trim characters
SQL
1 vote107 views1 answer
Delete triger pl pg sql
SQL
8 votes145 views1 answer
Racle create auto increment column
SQL
0 vote117 views1 answer
How to login to mysql in homestead
SQL
1 vote132 views1 answer
Sql select sum group by id laravel
SQL
1 vote156 views4 answers
How to check table in postgresql from terminal
SQL
0 vote130 views1 answer
Reset postgres table index to next max value
SQL
0 vote122 views1 answer
Oracle service name view
SQL