MIN

声明

MIN([ DISTINCT | ALL ] expr) OVER (analytic_clause)

说明

返回指定数据中的最小值。

MIN() 的取值可以是一个字符串参数，此时函数返回最小字符串值。

• DISTINCT 关键字表示查找 expr 的不同值的最小值，然而，这产生的结果与省略 DISTINCT 的结果相同。

• ALL 关键字表示查找所有 expr 的值，缺省为 ALL。

示例

CREATE TABLE EXPLOYEES(LAST_NAME CHAR(10), SALARY DECIMAL, JOB_ID CHAR(32));
Query OK, 0 rows affected (0.036 sec)

INSERT INTO EXPLOYEES VALUES('JIM', 2000, 'CLEANER');
Query OK, 1 row affected (0.001 sec)

INSERT INTO EXPLOYEES VALUES('MIKE', 12000, 'ENGINEERING');
Query OK, 1 row affected (0.001 sec)

INSERT INTO EXPLOYEES VALUES('LILY', 13000, 'ENGINEERING');
Query OK, 1 row affected (0.001 sec)

INSERT INTO EXPLOYEES VALUES('TOM', 11000, 'ENGINEERING');
Query OK, 1 row affected (0.001 sec)

SELECT LAST_NAME, MIN(SALARY) OVER(PARTITION BY JOB_ID) MIN_S FROM EXPLOYEES;
+-----------+-------+
| LAST_NAME | MIN_S |
+-----------+-------+
| JIM       |  2000 |
| MIKE      | 11000 |
| LILY      | 11000 |
| TOM       | 11000 |
+-----------+-------+
4 rows in set (0.003 sec)