SQL问题，请大神赐教

260600sz

和大神们还有差距

with t1
as
(select 1 id,'S-2016-001' CODE,2 VALUE FROM DUAL UNION ALL
select 2 id,'S-2016-001' CODE,2 VALUE FROM DUAL UNION ALL
select 3 id,'S-2016-001' CODE,2 VALUE FROM DUAL UNION ALL
select 4 id,'S-2016-001' CODE,2 VALUE FROM DUAL UNION ALL
select 5 id,'S-2016-002' CODE,2 VALUE FROM DUAL UNION ALL
select 6 id,'S-2016-002' CODE,2 VALUE FROM DUAL UNION ALL

select 7 id,'S-2016-002' CODE,1 VALUE FROM DUAL UNION ALL
select 8 id,'S-2016-002' CODE,2 VALUE FROM DUAL UNION ALL
select 9 id,'S-2016-003' CODE,2 VALUE FROM DUAL UNION ALL

select 10 id,'S-2016-003' CODE,2 VALUE FROM DUAL UNION ALL
select 11 id,'S-2016-003' CODE,2 VALUE FROM DUAL UNION ALL
select 12 id,'S-2016-003' CODE,2 VALUE FROM DUAL
)

,t2 as
(
SELECT ID,CODE,value,decode(lag(VALUE,1,value)OVER(PARTITION BY CODE ORDER BY ID),value,0,1)flag
FROM T1
)
select id,code,value from
(
select id,code,value,sum(flag)over(partition by code order by code)cnt from t2

)
where cnt=0