---
title: "oracle内建函数least()"
author: "demojava"
date: "2012-04-12T15:51:00Z"
tags: []
categories: ["数据库"]
slug: "oracle-least"
draft: false
lastmod: "2012-04-12T15:51:00Z"
id: 1484565
url: "https://demojava.iteye.com/blog/1484565"
---

least()函数,用于求一组值中最小值.例如:  
1.select least(1,2) from dual;  
结果:1  
2.select least('阿','吧') from dual;  
结果:阿  
3.select least('阿','吧','1',1) from dual;  
结果:1  
比较智慧的运用:  
select max(least(2,4,9)) from dual;即在最小值里面找最大的.

转载：[http://space.itpub.net/226801/viewspace-686](http://space.itpub.net/226801/viewspace-686)