declare @ttb table(
[undid] [int] not null IDENTITY (1, 1) ,
[ID] [int] not null Primary key)
set RowCount 60
insert into @ttb select id from dbo.qqqq where Isction=0 and Isld=0 and QueeID<>3
SELECT * FROM dbo.qqqq WHERE ID in (select ID from @ttb where undid>40)
转载于:https://www.cnblogs.com/caicainiao/archive/2011/04/23/2025729.html
