表名:KAKAKU
字段名: KOJI_CD CHAR(5)
A1 DATE
A2 DATE
A3 DATE
A4 DATE
A5 DATE外部变量: B1,B2
如何处理一下设计:
1. A1 IS NOT NULL 的时候
A1 >= B1 AND A1 <= B2
2. A2 IS NOT NULL 的时候
A2 >= B1 AND A2 <= B2
3. A3 IS NOT NULL 的时候
A3 >= B1 AND A3 <= B2
4. A4 IS NOT NULL 的时候
A4 >= B1 AND A4 <= B2
......
.......请问以上如何写sql文。环境是,oracle +vb.net
字段名: KOJI_CD CHAR(5)
A1 DATE
A2 DATE
A3 DATE
A4 DATE
A5 DATE外部变量: B1,B2
如何处理一下设计:
1. A1 IS NOT NULL 的时候
A1 >= B1 AND A1 <= B2
2. A2 IS NOT NULL 的时候
A2 >= B1 AND A2 <= B2
3. A3 IS NOT NULL 的时候
A3 >= B1 AND A3 <= B2
4. A4 IS NOT NULL 的时候
A4 >= B1 AND A4 <= B2
......
.......请问以上如何写sql文。环境是,oracle +vb.net
CASE
WHEN A1 is not null THEN A1
WHEN A2 is not null THEN A2
...
ENDNVL(NVL(NVL(NVL(A1,A2),A3),A4),A5)NVL2(NVL2(A1,A2,A3),A4,A5)刚好^_^between B1 and B2