You are here
在oracle中，怎么将一个OR作为一个and条件？ 有大用 有大大用
星期日, 2021-09-12 00:13 — adminshiping1
where pc.status != 2 and (startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate)
-----------------------------这样也可以------------------------------------------------------
where pc.status != 2 and (( startDate between pc.projectStartDate and pc.projectEndDate) or (endDate between pc.projectStartDate and pc.projectEndDate))
--------------------------------
这个问题的分类应该是数据库软件编程的。
来自 https://zhidao.baidu.com/question/2010243176780792228.html
普通分类: