sqlserver ( Limit )

最新推荐文章于 2024-08-25 09:08:13 发布

peterpansh

最新推荐文章于 2024-08-25 09:08:13 发布

阅读量3.6k

点赞数

分类专栏： SQL 文章标签： sqlserver email

本文链接：https://blog.csdn.net/czcty/article/details/569861

版权

SQL 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

select count(*) as n from tblcontact where email='' and officeid_fk in
--select count(*) as n from tblcontact where email='' and firstname='' and lastname='' and officeid_fk in

(
select officeid_pk from tbloffice where companyid_fk in

(
select companyid_fk from tblMCOCControl where contactnum>0 and ( RecordID_pk >= (SELECT max(RecordID_pk) AS RecordID_pk FROM tblMCOCControl WHERE contactnum>0 and RecordID_pk IN (SELECT TOP 1 RecordID_pk FROM tblMCOCControl where contactnum>0)) )AND (RecordID_pk <= (SELECT MAX(RecordID_pk) AS RecordID_pk FROM tblMCOCControl WHERE contactnum>0 and RecordID_pk IN (SELECT TOP 1000 RecordID_pk FROM tblMCOCControl where contactnum>0 ))))

)