SQL - Duda obtenee datos

create table #test (col1 char(3), col2 int, col3 int)

insert into #test values('Pan',467, 4567)

insert into #test values('Swp',434, 4567)

insert into #test values('Pan',346, 4355)

insert into #test values('Dfr',353, 4355)

select col3, MAX(col2) as col2, MAX(col1) as col1

from #test

group by col3

WITH    q AS

        (

        SELECT  col1, col2, col3, ROW_NUMBER() OVER (PARTITION BY col1 ORDER BY col3) AS rn

        FROM    #test

        )

SELECT  *

FROM    q

WHERE   rn = 1