--如果要31到40条的话,试试下面 select top 10 p.ID,c.Name AS OrgName,p.SampleName,p.SampleNo, p.ReceivedDate,p.SamplingAddress,p.SamplingWay,t.[Status] from RHMS_PersonalTestInfo p,Comm_Organizations o,Comm_Contacts c,[RHMS_TestFlow] t where p.OID=o.ID AND o.OrgContactId=c.ID AND p.id IN (select top 40 p.ID,c.Name AS OrgName,p.SampleName,p.SampleNo, p.ReceivedDate,p.SamplingAddress,p.SamplingWay,t.[Status] from RHMS_PersonalTestInfo p,Comm_Organizations o,Comm_Contacts c,[RHMS_TestFlow] t where p.OID=o.ID AND o.OrgContactId=c.ID --要同前面那个select top 10的语句条件一致 order by p.ID desc) order by p.ID
select top 10 p.ID,c.Name AS OrgName,p.SampleName,p.SampleNo,
p.ReceivedDate,p.SamplingAddress,p.SamplingWay,t.[Status]
from RHMS_PersonalTestInfo p,Comm_Organizations o,Comm_Contacts c,[RHMS_TestFlow] t
where p.OID=o.ID AND o.OrgContactId=c.ID
AND p.id IN
(select top 40 p.ID,c.Name AS OrgName,p.SampleName,p.SampleNo,
p.ReceivedDate,p.SamplingAddress,p.SamplingWay,t.[Status]
from RHMS_PersonalTestInfo p,Comm_Organizations o,Comm_Contacts c,[RHMS_TestFlow] t
where p.OID=o.ID AND o.OrgContactId=c.ID --要同前面那个select top 10的语句条件一致
order by p.ID desc)
order by p.ID