662
社区成员




--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([c1] int,[c2] int,[c3] int)
Insert #T
select 1,1,1 union all
select 1,2,2 union all
select 1,3,3 union all
select 2,1,4 union all
select 2,2,5 union all
select 3,1,6 union all
select 3,2,7
Go
--测试数据结束
SELECT c1,c2,c3
FROM ( SELECT * ,
ROW_NUMBER() OVER ( PARTITION BY c1 ORDER BY c2 ) AS rn
FROM #T
) t
WHERE rn = 1