消除sql2000里的重复数据-mysql教程-PHP中文网

消除sql2000里的重复数据

php中文网

发布： 2016-06-07 14:55:01

原创

1349人浏览过

游标版 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

游标版
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

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

空心菜的米库

1，对界面进行了美化2，对文件里边相同代码进行了综合3，增加了点击次数统计，并对3次点击以上的域名增加热门字样4，对本站出售和个人出售进行了划分5，增加钻石状态说明6，增加了完整的后台界面7，增加对资料修改功能8，增加回收站，可以任意删除域名、恢复删除域名和永久删除数据9，还有其他的细节大家自己看~10.增加域名证书显示11.域名到期时间采用日历控件形式12.后台登陆添加了验证码功能13.还有很多

查看详情

SQL Server

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)

登录后复制