---
title: "排序查询 | OceanBase 文档中心"
description: 排序查询 ORDER BY 子句用于对查询结果按照一个或多个属性列进行升序（ASC）或降序（DESC）排列，默认为升序。 排序查询示例 单字段排序查询 按照 deptno 升序显示员工信息。 obclient> SELECT empname, deptno FROM emp ORDER BY deptno; +---…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 3.2.3 企业版 LTS

# 排序查询

更新时间：2023-07-18 17:25:59

ORDER BY 子句用于对查询结果按照一个或多个属性列进行升序（ASC）或降序（DESC）排列，默认为升序。

## 排序查询示例

### 单字段排序查询

- 按照 `deptno` 升序显示员工信息。

  ```sql
  obclient> SELECT empname, deptno FROM emp ORDER BY deptno;
  +---------+--------+
  | EMPNAME | DEPTNO |
  +---------+--------+
  | SMITH   |     20 |
  | SCOTT   |     25 |
  | BLAKE   |     30 |
  | ALLEN   |     35 |
  | JONES   |     40 |
  | FORD    |     45 |
  +---------+--------+
  6 rows in set

  ```
 - 按照 `deptno` 降序显示员工信息。

  ```sql
  obclient> SELECT empname, deptno FROM emp ORDER BY deptno DESC;
  +---------+--------+
  | EMPNAME | DEPTNO |
  +---------+--------+
  | FORD    |     45 |
  | JONES   |     40 |
  | ALLEN   |     35 |
  | BLAKE   |     30 |
  | SCOTT   |     25 |
  | SMITH   |     20 |
  +---------+--------+
  6 rows in set

  ```

### 多字段排序查询

按照 `deptno` 升序，`sal` 降序显示员工信息。

```sql
obclient> SELECT empname, deptno, sal FROM emp ORDER BY deptno ASC,sal DESC;
+---------+--------+------+
| EMPNAME | DEPTNO | SAL  |
+---------+--------+------+
| SMITH   |     20 |  800 |
| SCOTT   |     25 | 3000 |
| BLAKE   |     30 | 2850 |
| ALLEN   |     35 | 1600 |
| JONES   |     40 | 2975 |
| FORD    |     45 | 3000 |
+---------+--------+------+
6 rows in set

```

### 在 WHERE 子句之后排序

`ORDER BY` 可以在 `WHERE` 之后进行排序。示例如下：

```sql
obclient> SELECT empname, deptno,sal, HIREDATE FROM emp WHERE sal>=1000 ORDER BY HIREDATE;
+---------+--------+------+-----------+
| EMPNAME | DEPTNO | SAL  | HIREDATE  |
+---------+--------+------+-----------+
| ALLEN   |     35 | 1600 | 20-FEB-81 |
| JONES   |     40 | 2975 | 02-APR-81 |
| BLAKE   |     30 | 2850 | 01-MAY-81 |
| FORD    |     45 | 3000 | 05-DEC-81 |
| SCOTT   |     25 | 3000 | 15-JUL-87 |
+---------+--------+------+-----------+
5 rows in set

```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线