5.23. PostgreSQL ORDER BY statement

发布时间：2025-10-25 12:30:50 UTC

In PostgreSQL ORDER BY Used to sort one or more columns of data in ascending (ASC) or descending (DESC) order.

5.23.1. Grammar ¶

ORDER BY The basic syntax of the clause is as follows:

SELECT column-list
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, .. columnN] [ASC | DESC];

You can use one or more columns in ORDER BY, but you must make sure that the columns you want to sort must exist.

ASC Indicates ascending order DESC Indicates descending order.

5.23.2. Example ¶

Create the COMPANY table ( 下载 COMPANY SQL 文件 ), the data are as follows:

runoobdb# select * from COMPANY;
 id | name  | age | address   | salary
----+-------+-----+-----------+--------
  1 | Paul  |  32 | California|  20000
  2 | Allen |  25 | Texas     |  15000
  3 | Teddy |  23 | Norway    |  20000
  4 | Mark  |  25 | Rich-Mond |  65000
  5 | David |  27 | Texas     |  85000
  6 | Kim   |  22 | South-Hall|  45000
  7 | James |  24 | Houston   |  10000
(7 rows)

The following example will determine the results based on the AGE Field values are sorted in ascending order:

runoobdb=# SELECT * FROM COMPANY ORDER BY AGE ASC;

The following results are obtained:

 id | name  | age |                      address                       | salary
----+-------+-----+----------------------------------------------------+--------
| Kim   |  22 | South-Hall                                         |  45000
| Teddy |  23 | Norway                                             |  20000
| James |  24 | Houston                                            |  10000
| Mark  |  25 | Rich-Mond                                          |  65000
| Allen |  25 | Texas                                              |  15000
| David |  27 | Texas                                              |  85000
| Paul  |  32 | California                                         |  20000
(7 rows)

The following example will determine the results based on the NAME Field values and SALARY Sort the field values in ascending order:

runoobdb=# SELECT * FROM COMPANY ORDER BY NAME, SALARY ASC;

The following results are obtained:

 id | name  | age |                      address                       | salary
----+-------+-----+----------------------------------------------------+--------
| Allen |  25 | Texas                                              |  15000
| David |  27 | Texas                                              |  85000
| James |  24 | Houston                                            |  10000
| Kim   |  22 | South-Hall                                         |  45000
| Mark  |  25 | Rich-Mond                                          |  65000
| Paul  |  32 | California                                         |  20000
| Teddy |  23 | Norway                                             |  20000
(7 rows)

The following example will determine the results based on the NAME Field values are sorted in descending order:

runoobdb=# SELECT * FROM COMPANY ORDER BY NAME DESC;

The following results are obtained:

 id | name  | age |                      address                       | salary
----+-------+-----+----------------------------------------------------+--------
| Teddy |  23 | Norway                                             |  20000
| Paul  |  32 | California                                         |  20000
| Mark  |  25 | Rich-Mond                                          |  65000
| Kim   |  22 | South-Hall                                         |  45000
| James |  24 | Houston                                            |  10000
| David |  27 | Texas                                              |  85000
| Allen |  25 | Texas                                              |  15000
(7 rows)

文章链接： 5.23. PostgreSQL ORDER BY statement

Principles and Applications of WebGIS 37

Web Frameworks 49

Principles, Technologies, and Methods of Geographic Information Systems 102

In recent years, Geographic Information Systems (GIS) have undergone rapid development in both theoretical and practical dimensions. GIS has been widely applied for modeling and decision-making support across various fields such as urban management, regional planning, and environmental remediation, establishing geographic information as a vital component of the information era. The introduction of the “Digital Earth” concept has further accelerated the advancement of GIS, which serves as its technical foundation. Concurrently, scholars have been dedicated to theoretical research in areas like spatial cognition, spatial data uncertainty, and the formalization of spatial relationships. This reflects the dual nature of GIS as both an applied technology and an academic discipline, with the two aspects forming a mutually reinforcing cycle of progress.

Programming Language 353