笔记10 CROSS APPLY的应用：根据组名取出sales最大值的那个name

笔记10 CROSS APPLY的应用：根据组名取出sales最大值的那个name 

--CROSS APPLY的应用：根据组名取出sales最大值的那个name
declare @tb table([name] varchar(2),[group] varchar(2),[sales] int)
insert @tb
select 'aa','G1',3 union all
select 'bb','G1',5 union all
select 'cc','G2',4 union all
select 'dd','G2',3

SELECT *
FROM(
SELECT DISTINCT  [group]
FROM @tb
)A
CROSS APPLY(
SELECT TOP 1 *
FROM @tb BB
WHERE BB.[group] = A.[group]
ORDER BY sales DESC
)B