delete tb where id in(select top id from tb order by id desc)
delete userinfo where id in(select top 2 id from userinfo order by id desc)
修正 delete tb where id in(select top 2 id from tb order by id desc)
delete tb from tb t where id in (select top 2 id from tb order by id desc)
delete tb from tb t where id in (select top 2 id from tb order by id desc)复制,接份
create table tb(id int,name varchar(10)) insert into tb values(1 ,'小张') insert into tb values(2 ,'小明') insert into tb values(3 ,'小李') insert into tb values(4 ,'小周') insert into tb values(5 ,'小陈') godelete from tb where id in (select top 2 id from tb order by id desc)select * from tbdrop table tb/* id name ----------- ---------- 1 小张 2 小明 3 小李(所影响的行数为 3 行)*/
是SQL2000还是SQL2005中实现? 我也是初学者哦。 delete userinfo where id='4'
DELETE userinfo WHERE id in(SELECT TOP 2 id FROM student ORDER BY id DESC)
delete tab where id in ( select top 2 id from tab order by id desc )
delete userinfo where id in (select top 2 id from userinfo order by id desc 我只是学习的,不要分,我是复制学习的
where id in(select top id from tb order by id desc)
delete tb
where id in(select top 2 id from tb order by id desc)
delete tb from tb t where id in (select top 2 id from tb order by id desc)
delete tb from tb t where id in (select top 2 id from tb order by id desc)复制,接份
insert into tb values(1 ,'小张')
insert into tb values(2 ,'小明')
insert into tb values(3 ,'小李')
insert into tb values(4 ,'小周')
insert into tb values(5 ,'小陈')
godelete from tb where id in (select top 2 id from tb order by id desc)select * from tbdrop table tb/*
id name
----------- ----------
1 小张
2 小明
3 小李(所影响的行数为 3 行)*/
我也是初学者哦。
delete userinfo where id='4'
WHERE id in(SELECT TOP 2 id FROM student ORDER BY id DESC)
delete tab where id in (
select top 2 id from tab order by id desc
)
delete userinfo where id in (select top 2 id from userinfo order by id desc
我只是学习的,不要分,我是复制学习的