高玉昆
Post details: 判断俩个值的大小函数sign
Category: sql
比较大小
select decode(sign(变量1-变量2),-1,变量1,变量2) from dual; --取较小值
sign()函数根据某个值是0、正数还是负数，分别返回0、1、-1
GREATEST(var_1, var_2, var_3, etc);获取最大值
LEAST(var_1, var_2, var_3, etc);获取最小值
select greatest('3', '5') from dual
Comments:
No Comments for this post yet...
高玉昆
| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| << < | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||
Search
Categories
Archives
- September 2009 (2)
- August 2009 (3)
- July 2009 (1)
- June 2009 (11)
- May 2009 (5)
- April 2009 (2)
- March 2009 (2)
- February 2009 (1)
- December 2008 (9)
- November 2008 (1)
- October 2008 (5)
- September 2008 (11)
- More...
Choose skin
Linkblog
公益网站
Misc
Syndicate this blog 
What is RSS?
Who's Online?
Guest Users: 19powered by
Original b2evolution template design by Topanga based on the standard template by François PLANQUE.
