352
Oracle Least()函數
LEAST
The LEAST function returns the smallest expression in a list of expressions. All expressions after the first are implicitly converted to the data type of the first expression before the comparison.
To retrieve the largest expression in a list of expressions, use GREATEST.
The data type of the first expression.
LEAST (expr [, expr]...)
- expr
-
An expression.
Example 17-38 Finding the Shortest Text Expressions
The following statement returns the shortest string.
SHOW LEAST('Harry','Harriot','Harold')
Harry
Example 17-39 Finding the Smallest Numerical Expressions
The following statement selects the number with the smallest value.
SHOW LEAST (5, 3, 18) 3
原文地址：點擊打開鏈接
最後更新：2017-04-03 12:55:22
上一篇：
C# checkBox控件CheckedChanged與CheckedStateChanged區別
下一篇： C# dev gridcontrol “時間”字符串格式化
- error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)&#
- java.util.concurrent包(6)——CyclicBarrier使用
- 開發區塊鏈數字貨幣交易網站，數字貨幣交易所搭建
- Sql Server substring(expression, start, length)函數
- 雲存儲 之 OSS實戰進階分享
- vxWorks下dosFs文件係統的創建
- 《數據結構與抽象：Java語言描述（原書第4版）》一P.4.3 統一建模語言
- 中國黑客譜係
- 曆程剖析：阿裏雲自研HTAP數據庫的技術發展之路
- C#之"0x{0:x}"