例如表 tbshow中
idno entdt
205073001 2009-07-07
205073001 2006-05-08
205073001 2003-08-14
想删除剩下最近一条记录
5073001 2009-07-07
得怎么写语句 ?
------解决方案--------------------
- SQL code
delete t from tbshow t where exists(select 1 from tbshow where idno=t.idno and dntdt>t.entdt)