27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([name] nvarchar(22),[num1] int,[num2] int)
Insert #T
select N'A1',1,1 union all
select N'A1',1,2 union all
select N'A1',2,1 union all
select N'A1',2,2 union all
select N'A2',1,1 union all
select N'A2',1,2 union all
select N'A2',2,1
Go
--测试数据结束
SELECT name,
num1,
num2
FROM
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY name ORDER BY num1 DESC, num2 DESC) rn
FROM #T
) t
WHERE rn = 1;
select * from (
select ROW_NUMBER() over(partition by name order by num1 desc,num2 desc) rid,name,num1,num2 from 表)A
where A.rid=1