BigRain

摘要： update l set l.state='X'from links linner join( select max(ID) as ID from links where [time]>'2013/1/1' and state<>'X' group by title having count(1)>5) bon l.id=b.id and 1=2--具体重复的记录 l.id>=a.minID and l.id<=a.maxID 采用主键筛选，加快筛选效率select l.ID,l.title,l.url,l.a 阅读全文