最新回答 / 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...
2020-11-23
最新回答 / 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 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;
最新回答 / 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
-- 設置列寬
col ci_id format a20
col stu_names format a20
--行顯示設置
set linesize 100
-- sql查詢語句
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
--行顯示設置
set linesize 100
-- sql查詢語句
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;
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;