消除sql2000里的重复数据

游标版声明 @id1 int,@oldid int,@e_REcordid int ,@Olde_REcordid int 声明价格游标 SELECT id ,E_recordId FROM evaeve order by E_recordId desc 开盘价格 FETCH NEXT FROM Price into @oldid,@Olde_REcordid while @@ fetch_status = 0

游标版
声明@id1 int,@oldid int,@e_REcordid int,@Olde_REcordid int
声明价格游标
FOR SELECT id ,E_recordId FROM evaeve order by E_recordId desc
开盘价格
从价格中提取下一个内容到 @oldid,@Olde_REcordid
同时 @@fetch_status = 0
开始
从价格中提取下一个内容
到 @id1,@e_REcordid

if @Olde_REcordid=@e_REcordid
BEGIN
  从 evaeve where id=@id1
end 删除
set @oldid=@id1
set @Olde_REcordid=@e_REcordid
end
收盘价
DEALLOCATE 价格

sql语句版
delete   from evaeve where id not in(  select max(id)  from evaeve group by   E_RecordID)

SQL服务器

declare @id1 int,@oldid int,@e_REcordid int ,@Olde_REcordid int
DECLARE price CURSOR
FOR SELECT id ,E_recordId FROM evaeve order by  E_recordId desc
OPEN price
FETCH NEXT FROM price  into @oldid,@Olde_REcordid
while @@fetch_status  = 0
begin
FETCH NEXT FROM price   
into @id1,@e_REcordid

if @Olde_REcordid=@e_REcordid
BEGIN
  delete from evaeve where id=@id1
end 
set @oldid=@id1
set @Olde_REcordid=@e_REcordid
end  
close price 
DEALLOCATE price


delete   from evaeve where id not in(  select max(id)  from evaeve group by   E_RecordID)