最新回答 / weixin_慕工程1563154
https://vk.com/album712774205_283343594https://vk.com/album712534118_283394337https://vk.com/album712782889_283692329https://vk.com/album712781708_283394356https://vk.com/album712782082_283439784https://vk.com/album712782483_285969412https://vk.com/album7...
最新回答 / weixin_慕工程1563154
https://vk.com/album712782082_283438619https://vk.com/album712782483_285968092https://vk.com/album712781332_283438637https://vk.com/album712772904_281936543https://vk.com/album712774205_283342558https://vk.com/album712534118_283393249https://vk.com/album7...
2020-11-18
SELECT
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
2020-10-13
SELECT
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
2020-10-13
select ci_id, wm_concat(name)
from (select ci_id, decode(instr(stu_ids, stu_id), 0, '', stu_name) name
from (select c.ci_id, c.stu_ids, s.stu_id, s.stu_name
from pm_ci c, pm_stu s))
group by ci_id;
from (select ci_id, decode(instr(stu_ids, stu_id), 0, '', stu_name) name
from (select c.ci_id, c.stu_ids, s.stu_id, s.stu_name
from pm_ci c, pm_stu s))
group by ci_id;
2020-06-16
select pc.ci_id,wm_cancat(ps.stu_name) stu names from pm_ci pc ,pm_stu ps where instr( pc.stu_ids,ps.stu_id)>0
group by pc.ci_id;
group by pc.ci_id;
2020-05-11
最新回答 / weixin_慕工程1563154
https://vk.com/album712774205_283341295https://vk.com/album712534118_283391900https://vk.com/album712782889_283689778https://vk.com/album712781708_283391929https://vk.com/album712782082_283437408https://vk.com/album712782483_285967022https://vk.com/album7...
2020-04-15
最新回答 / weixin_慕工程1563154
https://vk.com/album712774205_283341295https://vk.com/album712534118_283391900https://vk.com/album712782889_283689778https://vk.com/album712781708_283391929https://vk.com/album712782082_283437408https://vk.com/album712782483_285967022https://vk.com/album7...
2020-03-28
-- 設(shè)置列寬
col ci_id format a20
col stu_names format a20
--行顯示設(shè)置
set linesize 100
-- sql查詢(xún)語(yǔ)句
select pc.ci_id ci_id,wm_concat(pt.stu_name) stu_names
from pm_ci pc,pm_stu pt
where instr(pc.stu_ids,pt.stu_id)>0
group by pc.ci_id;
col ci_id format a20
col stu_names format a20
--行顯示設(shè)置
set linesize 100
-- sql查詢(xún)語(yǔ)句
select pc.ci_id ci_id,wm_concat(pt.stu_name) stu_names
from pm_ci pc,pm_stu pt
where instr(pc.stu_ids,pt.stu_id)>0
group by pc.ci_id;
2020-02-28
select *
from (select rownum rm,e1.* from (select * from emp order by sal desc) e1 where rownum<=8) e2
where rm>=5;
from (select rownum rm,e1.* from (select * from emp order by sal desc) e1 where rownum<=8) e2
where rm>=5;