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}"