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 vote276 views1 answer
Delete row mssql
SQL
0 vote291 views1 answer
Drush run sql select
SQL
0 vote298 views1 answer
Python connect to mysql in settings.py
SQL
0 vote271 views1 answer
Mysql auto increment default value with prefix month and year
SQL
7 votes292 views2 answers
Oracle sql drop index
SQL
0 vote247 views2 answers
Postgresql could not start server mac
SQL
0 vote298 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote272 views1 answer
Sql oracle update multiple rows
SQL
2 votes286 views4 answers
Mysql select into new table
SQL
0 vote273 views1 answer
Fetch second word from a string in ms sql
SQL