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 vote264 views2 answers
Get day in sql
SQL
2 votes256 views1 answer
Sql like variable
SQL
0 vote275 views1 answer
Sql server change schema of a table
SQL
0 vote265 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote291 views1 answer
Python sql last insertend
SQL
1 vote263 views3 answers
Sql server get week dates from week number
SQL
8 votes408 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote273 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote276 views1 answer
Mysql event last execution
SQL
1 vote286 views2 answers
Procedure syntax
SQL