MYSQL官方文档需要撸一遍（待学习）

javartisan

于 2020-01-19 20:43:58 发布

阅读量470

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/Dax1n/article/details/104045009

版权

MySQL 专栏收录该内容

10 篇文章

订阅专栏

https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_json-arrayagg


select @rk := @rk + 1 as id,
       group_concat(revenue order by
                    field("month", "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")
                    separator ' ')
from Department,
     (select @rk := 0) rk
group by month;

MYSQL官方文档需要撸一遍