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 vote177 views2 answers
Mysql insert into multiple tables
SQL
3 votes153 views1 answer
Sql replace character in string in all records
SQL
0 vote177 views1 answer
Oracle sql developer closed connection
SQL
9 votes168 views2 answers
Mysql change value
SQL
15 votes188 views6 answers
Laravel db transaction
SQL
0 vote165 views1 answer
SQL isnumeric DB2
SQL
1 vote177 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote183 views1 answer
Sql script to remove default from column
SQL
0 vote182 views1 answer
Clear query cache sql server
SQL
4 votes167 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL