설명이 많이 누락된 것 같네요. 파라메터로 f값 1, g값 2, h값 3을 넣어주면 a, b로 묶어보았을 때 해당 값이 없으면 값을 넣어주겠다는 건가요? 헷갈리네요.

네 파라메터 값을 F = 1, G = 2, H = 3 을 넣었을경우입니다. 데이터는 고정으로 B 1,2,3,4,5,6 나와야 하고요..

F,G,H 를 CASE문으로 해봤는데 잘 안되서 질문드린겁니다 ㅠ

with test (a, b, d, e)
as (
select 'K2','1','1',null from dual union all
select 'K2','2','1',null from dual union all
select 'K2','3','1','20170119' from dual union all
select 'K2','3','2','20170119' from dual union all
select 'K2','4','1','20170119' from dual union all
select 'K2','5','1','20170119' from dual union all
select 'K2','6','1',null from dual 
)
,t as (
select a
, b
, trunc(sysdate - to_date(e,'YYYYMMDDHH24MISS'),0) as c
, d
, e
, case when d = '1' then '1' end f
, case when d = '2' or e is null then '2' end g               
, case when d = '3' or e is null then '3' end h
, row_number() over(partition by a, b order by b) rn
from test
where d < 4
)
select
a,b,c,d,e
,nvl(f,(case when fmax is null then case when rn = fmin then fval end end)) f
,nvl(g,(case when gmax is null then case when rn = gmin then gval end end)) g
,nvl(h,(case when hmax is null then case when rn = hmin then hval end end)) h
from
(
select a,b,c,d,e,f,g,h
      ,max(f) over(partition by a, b) fmax
      ,max(g) over(partition by a, b) gmax
      ,max(h) over(partition by a, b) hmax
      ,min(nvl2(f,null,rn)) over(partition by a, b order by rn) fmin
      ,min(nvl2(g,null,rn)) over(partition by a, b order by rn) gmin
      ,min(nvl2(h,null,rn)) over(partition by a, b order by rn) hmin
      ,rn
 from t
), (select :f fval, :g gval, :h hval from dual)          

by jkson 감사합니다.^^

여차여차 수정좀 해서 완성했습니다.

좋은하루되세요~