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 vote129 views1 answer
Ignore case in string sql
SQL
0 vote184 views1 answer
Ora 00001 error catch plsql
SQL
1 vote153 views1 answer
Sql order by timestamp
SQL
0 vote168 views1 answer
Print hello world in plsql
SQL
10 votes138 views2 answers
Forgot my mysql password mac
SQL
0 vote132 views3 answers
How to increase size of column in sql
SQL
1 vote154 views1 answer
Print year of a date sql
SQL
5 votes217 views2 answers
Mysql date greater than 30 days
SQL
0 vote126 views1 answer
Renommer table sql
SQL
0 vote125 views1 answer
Sql get count without group by
SQL