SQL中的or 的用法

最新推荐文章于 2025-05-21 13:38:33 发布

转载最新推荐文章于 2025-05-21 13:38:33 发布 · 777 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/itchenfirst/p/7305975.html

文章标签：

#数据库 #移动开发

select top 10 * from calls_item_package where 1=1 and parentNo = 'UU1501467168003' and orderPlan = '1' and (datediff(HH ,limtDate,getdate())<=6 or limtDate is null) and status != 2 and itemid not in (select top 0 itemid from calls_item_package where 1=1 and parentNo = 'UU1501467168003' and orderPlan = 1 and (datediff(HH ,limtDate,getdate())<=6 or limtDate is null) and status != 2 order by dataPriority desc,level desc ) order by dataPriority desc,level desc

有 or 的时候必须使用括号括起来，不然就会出错啦

转载于:https://www.cnblogs.com/itchenfirst/p/7305975.html