PostgreSQL ORDER BY 子句用于根据一个或多个列以升序或降序对数据进行排序。
Order By - 语法
ORDER BY子句的基本语法如下-
SELECT column-list FROM table_name [WHERE condition] [ORDER BY column1, column2, .. columnN] [ASC | DESC];
您可以在ORDER BY子句中使用多个列。确保要用于排序的任何列,该列都应在column-list中可用。
Order By - 示例
考虑表 COMPANY 具有以下记录:
testdb# select * from COMPANY; id | name | age | address | salary ----+-------+-----+-----------+-------- 1 | Paul | 32 | California| 20000 2 | Learnfk | 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)
以下是一个示例,它将按SALARY升序对输出进行排序-
testdb=# SELECT * FROM COMPANY ORDER BY AGE ASC;
这将产生以下输出-
id | name | age | address | salary ----+-------+-----+------------+-------- 6 | Kim | 22 | South-Hall | 45000 3 | Teddy | 23 | Norway | 20000 7 | James | 24 | Houston | 10000 8 | Paul | 24 | Houston | 20000 4 | Mark | 25 | Rich-Mond | 65000 2 | Learnfk | 25 | Texas | 15000 5 | David | 27 | Texas | 85000 1 | Paul | 32 | California | 20000 9 | James | 44 | Norway | 5000 10 | James | 45 | Texas | 5000 (10 rows)
以下是一个示例,它将按照NAME和SALARY的升序对输出进行排序-
testdb=# SELECT * FROM COMPANY ORDER BY NAME, SALARY ASC;
这将产生以下输出-
id | name | age | address | salary ----+-------+-----+--------------+-------- 2 | Learnfk | 25 | Texas | 15000 5 | David | 27 | Texas | 85000 10 | James | 45 | Texas | 5000 9 | James | 44 | Norway | 5000 7 | James | 24 | Houston | 10000 6 | Kim | 22 | South-Hall | 45000 4 | Mark | 25 | Rich-Mond | 65000 1 | Paul | 32 | California | 20000 8 | Paul | 24 | Houston | 20000 3 | Teddy | 23 | Norway | 20000 (10 rows)
以下是一个示例,它将按照NAME的降序对输出进行排序-
testdb=# SELECT * FROM COMPANY ORDER BY NAME DESC;
这将产生以下输出-
id | name | age | address | salary ----+-------+-----+------------+-------- 3 | Teddy | 23 | Norway | 20000 1 | Paul | 32 | California | 20000 8 | Paul | 24 | Houston | 20000 4 | Mark | 25 | Rich-Mond | 65000 6 | Kim | 22 | South-Hall | 45000 7 | James | 24 | Houston | 10000 9 | James | 44 | Norway | 5000 10 | James | 45 | Texas | 5000 5 | David | 27 | Texas | 85000 2 | Learnfk | 25 | Texas | 15000 (10 rows)
参考链接
https://www.learnfk.com/postgresql/postgresql-order-by.html
标签:24,25,PostgreSQL,James,无涯,ORDER,20000,Order,Texas From: https://blog.51cto.com/u_14033984/8956363