oracle数据库查询多行数据使用wmsys.wm_concat()合并

  table userinfopay

  user_ id     start_time     end_time              pay

     1              2014              2015                  5000

     1              2016              2018                  8000

     2              2014              2015                  4500

     2              2016              2017                  7000

     2              2018              2020                 15000

  SQL:  

  select  user_id,  wmsys.wm_concat(start_time || '--' ||  end_time ||'绩效奖金为:' || pay)  as  userinfo  from userinfopay 

  group  by  user_id   order by start_time asc ;

  RESULT:    

      user_id                                                                   userinfo

         1                                       2014--2015绩效奖金为:5000,2016--2018绩效奖金为:8000

         2                 2014--2015绩效奖金为:4500,2016--2017绩效奖金为:7000,2018--2020绩效奖金为:15000