;with test as ( select * from 表名 where 字段名='值' )) --假设test里面有一列名为name select * from test A where Exists(select Max(lasteditdt) from test A1 where A1.name=A.name本回答被网友采纳
第2个回答 2016-08-04
select top 1 * from 表名 where 字段名='值' order by DataTimeColumnName desc