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

4 votes328 views1 answer
Create db table
SQL
2 votes318 views1 answer
Mysql time ago difference
SQL
5 votes301 views2 answers
Create table
SQL
2 votes348 views1 answer
Sql get the name of user pc
SQL
0 vote332 views1 answer
Fill up postgres db
SQL
1 vote336 views1 answer
SQL date part only of datetime
SQL
0 vote306 views1 answer
Postgresql subquery
SQL
24 votes338 views4 answers
Delete db postgres
SQL
0 vote342 views2 answers
Py sqlite if entry exists
SQL
19 votes338 views6 answers
What is mySQL
SQL