select * From (Select fs.id ,fs.other ,ROW_NUMBER() Over (Partition by fs.id --指定记录的ID order by fs.updatetime DESC --时间优先级 ) Fsp From Storage AS fs ) AS Storage Where Fsp = 1
select * From (Select fs.id ,fs.other ,ROW_NUMBER() Over (Partition by fs.id --指定记录的ID order by fs.updatetime DESC --时间优先级 ) Fsp From Storage AS fs ) AS Storage Where Fsp = 1