select sr.batch_no,
GROUP_CONCAT(DISTINCT(s.risk_type) Separator ‘_’) riskType
from adc_fund_table_scene s
inner join adc_fund_table_scene_drill_record sr on s.scene_code = sr.scene_code
GROUP BY sr.batch_no
order by sr.batch_no desc
limit 0,#pageSize#
Mysql中GROUP_CONCAT函数的使用:
最新推荐文章于 2021-10-03 20:03:57 发布