ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> DB2 >> DB2中 between and 的边界

DB2中 between and 的边界

来源:网络整理     时间:2015-06-26     关键词:

本篇文章主要介绍了"DB2中 between and 的边界",主要涉及到方面的内容,对于DB2感兴趣的同学可以参考一下: 在DB2是中经过测试发现:between and == >= and <eg:SELECT *FROM TB2096_51WHERE PAR...

在DB2是中经过测试发现:

between and ==    >=  and <

eg:

SELECT *
FROM TB2096_51
WHERE PARTY_ID ='7590950f99d34410b123ad3821a5965e'
AND CUST_LEVEL_FACTOR='200000000050'
AND FACTOR_VAL_CHG_QTY=0
--AND CREATED_TIME >= '2015-05-18 18:49:52' and CREATED_TIME <'2015-05-18 18:49:53'
        AND CREATED_TIME BETWEEN  '2015-05-18 18:49:52' AND '2015-05-18 18:49:53'
AND AMOUNT>0
AND END_TIME > CURRENT_TIMESTAMP WITH UR

两句加粗效果一样的。

2015-05-26

writed by page_qiu

以上就介绍了DB2中 between and 的边界,包括了方面的内容,希望对DB2有兴趣的朋友有所帮助。

本文网址链接:http://www.codes51.com/article/detail_144627.html

相关图片

相关文章