sql 按一个字段剔重，查询多个字段

表结构：id唯一，age列有重复的，按age去重，查询所有字段

SELECT [id]
      ,[name]
      ,[age]
  FROM [YIBAI].[dbo].[test]
GO

按age去重查询多个字段:

select * from [test] where id in (select max(id) from [test] group by [age])