結(jié)果為啥順序不一樣，子查詢的結(jié)果我也測試過了，挺正常啊。
SELECT?T.CI_ID,?WM_CONCAT(T.STU_NAME) ??FROM?(SELECT?S.STU_NAME,?C.CI_ID,?INSTR(C.STU_IDS,?S.STU_ID) ??????????FROM?PM_CI?C,?PM_STU?S ?????????WHERE?INSTR(C.STU_IDS,?S.STU_ID)?>?0)?T ?GROUP?BY?T.CI_ID
SELECT S.STU_NAME, C.CI_ID, INSTR(C.STU_IDS, S.STU_ID)
? ? ? ? ? FROM PM_CI C, PM_STU S
? ? ? ? ?WHERE INSTR(C.STU_IDS, S.STU_ID) > 0
子查詢結(jié)果
2020-05-28
select ci_id,MAX(M) from (
select ci_id,wm_concat(stu_name) over (partition by c.ci_id order by s.stu_id)m from pm_ci c,pm_stu s where instr(c.stu_ids,s.stu_id)>0)e group by e.ci_id;
2019-09-20
vm_concat（）函數(shù)拼接得到的結(jié)果是亂序的，需要在給他排序，好像要借助