方法一:用游标实现,用一个变量来技数就可以了。 方法二:select top 30 * from into newtable from oldtable select * from newtable where pkcolume not in (select top 5 pkcolume from newtable)
insert into t4 values(1,'zhao') insert into t4 values(2,'qian') insert into t4 values(3,'zhao')
方法二:select top 30 * from into newtable from oldtable
select * from newtable where pkcolume not in
(select top 5 pkcolume from newtable)
insert into t4 values(2,'qian')
insert into t4 values(3,'zhao')
不明白可以再问