本帖最后由 jeevan_yu 于 2014-1-10 17:35 编辑
with a as
(select '1' id,
'1-11Q' HM,
'72364' CDSC_ID,
'T-2-3' CDSC_NAME,
date '2012-12-25' CDSC_EFF_DT
from dual
union all
select '1',
'1-11Q' HM,
'72364' CDSC_ID,
'T-2-3-加' CDSC_NAME,
date '2012-12-24' CDSC_EFF_DT
from dual
union all
select '2',
'1-117' HM,
'76161' CDSC_ID,
'T-1-1' CDSC_NAME,
date '2012-12-24' CDSC_EFF_DT
from dual
union all
select '2',
'1-117' HM,
'76161' CDSC_ID,
'T-1-1-副' CDSC_NAME,
date '2012-12-24' CDSC_EFF_DT
from dual
union all
select '3',
'1-1RE' HM,
'761916' CDSC_ID,
'Q-3-5' CDSC_NAME,
date '2012-12-24' CDSC_EFF_DT
from dual
union all
select '4',
'1-11P ' HM,
'719113' CDSC_ID,
'D-4-5 ' CDSC_NAME,
date '2012-12-24' CDSC_EFF_DT
from dual
union all
select '5',
'1-1OA' HM,
'761916' CDSC_ID,
'V-6-5 ' CDSC_NAME,
date '2012-12-24' CDSC_EFF_DT
from dual)
select t1.*
from a t1
where (t1.id, t1.cdsc_id) in
(select id, cdsc_id
from (select *
from a
where a.id in ('1', '2', '3', '4', '5')
order by cdsc_id --这里可以
) t2
where t1.id = t2.id
--order by id,cdsc_id这里就无效
) |