declare @Reqeustid int
set @Requestid = 1500
while(@Requestid < 3000)
begin
delete from ItemRequestImage where TransactionNumber in
(select top 2 TransactionNumber from ItemRequestImage where requestid = @Requestid)
and requestid = @Requestid
set @Requestid = @Requestid + 1
end
对1500条数据循环Delete top.