delete from table where id in(select id from table where in('工','上','旧'))
alter table a add newid int identity(1,1) delete table a where a.newid in(select max(newid) from a group by bh) alter table a drop column newid
以上是删除最后一条的,第一条应该是: alter table a add newid int identity(1,1) delete table a where a.newid in(select min(newid) from a group by bh) alter table a drop column newid
有点小错误 该是这样的 alter table a add newid int identity(1,1) delete from a where a.newid in(select max(newid) from a group by bh) alter table a drop column newid
如果是删除重复的记录(需要保留一条) yoki(小马哥) 的真确
delete a where name =(select top 1 name from a as c where c.id=a.id)
delete table a where a.newid in(select max(newid) from a group by bh)
alter table a drop column newid
alter table a add newid int identity(1,1)
delete table a where a.newid in(select min(newid) from a group by bh)
alter table a drop column newid
该是这样的
alter table a add newid int identity(1,1)
delete from a where a.newid in(select max(newid) from a group by bh)
alter table a drop column newid
yoki(小马哥) 的真确