在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的

来源：学生作业帮助网 编辑：作业帮 时间：2024/06/17 06:45:46
在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的
x){:gE~QbrNku5=tCۓ OvzwΓ ļgs>ٽ;<#(U Y$XVH($*$g&@*y)`"T(dO[=]7@WtRZv,y6m-Q_d$}ߐwO~6oγvgS! PZ(Xuc^_ 6v6#>a{E&]lsOv/ū' } JbSa$BIn{q]S@i}gS7<]t{!iWt$ف2r_D

在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的
在oracle中,怎么将一个OR作为一个and条件?
where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate
其实这个startDate和endDate的判断的这个or的结果是前面where整个条件中的一个and条件.请问这个该怎么写?

在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的
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))
--------------------------------
这个问题的分类应该是数据库软件编程的.