求SQL～"ACCESS"数据库! 如何删除重复数据且保留最新插入的一条重复数据...
发布网友
共1个回答
热心网友
delete from table where (taskid,createtime) not in (select taskid,max(createtime) from table group by taskid)
试一下吧
