Oracle Least()函数
Oracle 函数 Least
2023-09-14 09:02:14 时间
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 t
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. Return Value The data type of the first expression. Syntax LEAST (expr [, expr]...) Arguments
Example 17-38 Finding the Shortest Text Expressions
Example 17-39 Finding the Smallest Numerical Expressions
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. Return Value The data type of the first expression. Syntax LEAST (expr [, expr]...) Arguments
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
原文地址:点击打开链接
相关文章
- 深入理解Oracle数据库归档日志位置(oracle归档日志位置)
- 控制从Oracle中控制IP访问的安全措施(oracle访问ip)
- Oracle函数实现变量赋值(oracle函数赋值)
- Oracle高效利用多列索引优化查询效率(oracle多列索引)
- 使用Oracle内置函数比较大小(oracle判断大小函数)
- Oracle数据库连接技术:建立全新的连接(oracle数据库连接包)
- Oracle数据库集成:一步晋升企业数据技能(oracle数据库集成)
- Oracle中使用开窗函数加速查询(oracle的开窗函数)
- 深入理解 Oracle 返回表函数(oracle返回表函数)
- 利用Oracle中IN函数进行数据查询(oracle带in函数)
- Oracle 转列函数:实现数据的逆转化(oracle转列函数)
- Oracle自动表分区技术在数据库中的应用(oracle自动表分区)
- Oracle出现空洞,如何解决(oracle出来空函数)
- Oracle以几个字节的力量改变世界(oracle 几个字节)
- 使用Oracle中的进位函数精确进行科学计算(oracle中的进位函数)
- Oracle中汇总函数的应用(oracle中汇总函数)
- Oracle中使用排序函数实现数据高效排序(oracle中排序函数)
- 使用Oracle中函数轻松获取每月最后一天(oracle中截取到月)
- 使用Oracle中四分位函数洞悉数据真实性(oracle中四分位函数)
- 函数利用Oracle中的右截取函数展示数据(oracle中右截取)
- 掌握Oracle中DML命令的重要性(oracle中dml命令)
- Oracle非免费体验也可收获(oracle不能免费下载)
- Oracle函数SUMIF快速求和(oracle sumif)
- 提升技能,及时挑战 Oracle OCP考试(oracle ocp吧)