select ci_id, wm_concat(STU_NAME) STU_NAME
from(select c.CI_ID, s.STU_NAME
from pm_ci c, pm_stu s
where instr(c.STU_IDS,s.STU_ID)>0)
group by ci_id;
from(select c.CI_ID, s.STU_NAME
from pm_ci c, pm_stu s
where instr(c.STU_IDS,s.STU_ID)>0)
group by ci_id;
2015-10-20
select rownum,ename,sal
from(select * from emp order by sal desc)
where rownum<=3;
from(select * from emp order by sal desc)
where rownum<=3;
2015-10-03