SELECT * FROM ( SELECT A.*, ROWNUM RN FROM ( select t.bookname,cc_concat(distinct d.deptname) department,cc_concat(distinct p.chinesename) personName ,t.personid from t_crm_book_range t left join t_crm_person p on t.range_personid = p.personid left join t_crm_dept d on p.organid = d.deptcode where 1=1 and t.companyno='603886' group by t.bookname,t.personid ) A WHERE ROWNUM <100000 ) p WHERE RN >= 1 cc_concat()这个函数就是和网上zh_concat是一样的,只是返回值是clob类型的数据量有1万多个中文名字
SELECT A.*, ROWNUM RN FROM (
select t.bookname,cc_concat(distinct d.deptname) department,cc_concat(distinct p.chinesename) personName ,t.personid
from t_crm_book_range t left join t_crm_person p on t.range_personid = p.personid
left join t_crm_dept d on p.organid = d.deptcode where 1=1
and t.companyno='603886'
group by t.bookname,t.personid
) A WHERE ROWNUM <100000
) p
WHERE RN >= 1
cc_concat()这个函数就是和网上zh_concat是一样的,只是返回值是clob类型的数据量有1万多个中文名字