22,300
社区成员




with cte as
(
select top 3 *
from dbo.table_a
order by id desc;
)
insert into dbo.table_b
select * from cte;
with cte as
(
select top 3 *
from dbo.table_a
order by id desc;
)
drop table cte;
insert into B select top 3 * from A order by 时间字段 desc
delete A where 时间字段 in (select top 3 时间字段 from A order by 时间字段 desc)