select id,row_number() over(order by id desc) as [row]
from [t1]
where code=@code
)
delete from t1 from t1 s inner join w on s.id=w.id
where w.row>100;
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!
重学计算机组成原理(七)- 程序无法同时在Linux和Windows下运行?
网友评论