表结构: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])
表结构: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])