오라클 그룹내 중복 데이터 에서 하나의 데이터 뽑아내기

티스토리 뷰

DEV/DB

초록매실원액 2017. 7. 3. 17:04

with temp as(

select '1' idx , '10' dept , '20170703' as lastm ,'기타' as data_etc from dual union all

select '2' idx , '20' dept , '20170704' as lastm ,'정상' as data_etc from dual union all

select '2' idx , '20' dept , '20170705' as lastm ,'비정상' as data_etc from dual union all

select '3' idx , '40' dept , '20170703' as lastm ,'기타' as data_etc from dual union all

select '3' idx , '40' dept , '20170701' as lastm ,'기타' as data_etc from dual union all

select '4' idx , '60' dept , '20170703' as lastm ,'기타' as data_etc from dual union all

select '4' idx , '60' dept , '20170702' as lastm ,'기타' as data_etc from dual

)

select *

from (

select a.*

, row_number() over( partition by idx, dept order by lastm desc) rnk

from temp a

)

where rnk = 1

order by idx

MongoDB란? 비전공자를 위한 핵심 개념부터 활용법까지 완전 정복 가이드 (1)	2026.01.01
데이터베이스, 그거 먹는 건가요? (1)	2026.01.01
ibatis remapResults (0)	2016.10.28
index 리빌드 (0)	2015.11.26
PrepareStatment(#)와 Statment($) (0)	2015.11.26

공유하기 링크

공지사항

최근에 올라온 글

최근에 달린 댓글

링크

글 보관함