Oracle LEAST
函式可取得多個輸入參數中的最小值。
SELECT LEAST(3, 5, 1) "LEAST" FROM DUAL;
+-------+
| LEAST |
+-------+
| 1 |
+-------+
SELECT LEAST('B', 'C', 'A') "LEAST" FROM DUAL;
+-------+
| LEAST |
+-------+
| A |
+-------+
SELECT LEAST(1.2, 3.5, 7.9) "LEAST" FROM DUAL;
+-------+
| LEAST |
+-------+
| 1.2 |
+-------+
3 則留言:
走了都不講的誒 XD
@Jack 就默默的走阿:D
加個 line 啊
張貼留言