아래그림처럼 중복되는 국적과 언어를 제거해서 보여주려고 합니다.
오라클인데 저는 오히려 이런 쿼리가 매우 어렵네요.
검색해보다 도저히 몰라서 물어봅니다.
답변 좀 부탁드립니다.
감사합니다.
아래는 테스트 쿼리 첨부했습니다.
with test_table as
(
select '일본' as nation, '2011' as year, '3000' as money, 'japanese' as language from dual
union
select '일본' as nation, '2012' as year, '4000' as money, 'japanese' as language from dual
union
select '일본' as nation, '2013' as year, '5000' as money, 'japanese' as language from dual
union
select '한국' as nation, '2012' as year, '1000' as money, 'korean' as language from dual
union
select '한국' as nation, '2013' as year, '2000' as money, 'korean' as language from dual
union
select '미국' as nation, '2013' as year, '7000' as money, 'english' as language from dual
)
select *
from test_table
order by nation, year
예전에 다른 분께서도 MS-SQL에서 비슷한 질문을 하셔서 답변 드린 적이 있는데,
위처럼 ROW_NUMBER 함수를 이용하시면 될 듯 합니다 : )