3. group_concat与oracle中wm_concat用法一样

Posted on 2017-03-28 14:37  zkx4213  阅读(677)  评论(0编辑  收藏  举报

例子如下:

select
  group_concat(rp.ROLE_ID)
from
  eic_right_role_operator rp
where
  rp.OPERATOR_ID = #id#

Copyright © 2024 zkx4213
Powered by .NET 8.0 on Kubernetes