wm_concat()
这个函数可以把结果合并成一行用逗号隔开
select wmsys.wm_concat(SF) as TOP3 from (
select SF, sum(ZZTS) as ZTS
from DM_YYZZSJTJ_YPZZB
group by SF
order by ZTS
)
where rownum<=3
wm_concat()
这个函数可以把结果合并成一行用逗号隔开
select wmsys.wm_concat(SF) as TOP3 from (
select SF, sum(ZZTS) as ZTS
from DM_YYZZSJTJ_YPZZB
group by SF
order by ZTS
)
where rownum<=3