Oracle not in

最新推荐文章于 2025-12-09 09:24:19 发布

原创最新推荐文章于 2025-12-09 09:24:19 发布 · 109 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

--cuo
SELECT COUNT(*) FROM
(
       SELECT SP.FID FROM TServiceProject SP WHERE SP.FID NOT IN (SELECT T.FServiceProjectID FROM TZwFkxx T/*,TServiceProject SP WHERE SP.FID=T.FSERVICEPROJECTID GROUP BY T.FSERVICEPROJECTID*/)
)


--ok
SELECT COUNT(*) FROM
(
       SELECT SP.FID FROM TServiceProject SP WHERE SP.FID NOT IN (SELECT T.FServiceProjectID FROM TZwFkxx T,TServiceProject SP WHERE SP.FID=T.FSERVICEPROJECTID GROUP BY T.FSERVICEPROJECTID)
)