select a, max(b) from (
select '1' as a,'2016-09-01' as b,'세종대왕' as c union all
select '1','2016-09-02','이순신' union all
select '1','2016-09-03','신사임당' union all
select '1','2016-09-04','안중근' union all
select '1','2016-09-05','아인슈타인' ) x
group by a
1 | 2016-09-05 | 아인슈타인
의 결과가 나와야 하는데요..
group by 를 쓰면 1 | 2016-09-01 | ??
전문가님 도와주세요..ㅠㅠ
select a,b,c
from ( select a,b,c,ROW_NUMBER() over ( partition by a order by b desc ) rnk
from ( select '1' as a,'2016-09-01' as b,'세종대왕' as c union all
select '1','2016-09-02','이순신' union all
select '1','2016-09-03','신사임당' union all
select '1','2016-09-04','안중근' union all
select '1','2016-09-05','아인슈타인' ) x
) as a
where rnk=1