MYSQL 列转行
来源:互联网 发布:淘宝全屏海报轮播 编辑:程序博客网 时间:2024/06/05 19:31
SELECT
a.col1,
a.col2,
SUBSTRING_INDEX(
SUBSTRING_INDEX(a.datad, ',', s.`seq`),
',',
- 1
) AS aaa
FROM
(SELECT
col1,
col2,
SUBSTRING_INDEX(
GROUP_CONCAT(NAME
ORDER BY data_time),
',',
5
) AS datad
FROM
`test`
GROUP BY col1,
col2) a
JOIN sequce s
ON s.`seq` <= (
LENGTH(a.datad) - LENGTH(REPLACE(a.datad, ',', '')) + 1
)
ORDER BY a.col1,
a.col2 ;
a.col1,
a.col2,
SUBSTRING_INDEX(
SUBSTRING_INDEX(a.datad, ',', s.`seq`),
',',
- 1
) AS aaa
FROM
(SELECT
col1,
col2,
SUBSTRING_INDEX(
GROUP_CONCAT(NAME
ORDER BY data_time),
',',
5
) AS datad
FROM
`test`
GROUP BY col1,
col2) a
JOIN sequce s
ON s.`seq` <= (
LENGTH(a.datad) - LENGTH(REPLACE(a.datad, ',', '')) + 1
)
ORDER BY a.col1,
a.col2 ;
0 0
- mysql 列转行
- Mysql列转行
- mysql 列转行
- mysql中列转行
- MySQL列转行
- mysql 的列转行
- MYSQL 列转行
- mysql 动态列转行
- mysql行转列、列转行
- mysql group_concat列转行
- mysql行转列、列转行
- mysql行转列、列转行
- MySQL列转行统计数据
- mysql行转列、列转行
- mysql 列转行的技巧
- mysql 列转行,合并字段
- MySQL 列转行统计查询
- mysql 列转行,合并字段
- GreenDao使用心得
- actionbar、statusbar 浮动透明
- 渗透基础问答
- linux网络编程之TCP接口详解
- 各大热补丁方案分析和比较
- MYSQL 列转行
- 谈谈我对写博客的认识
- 杭电acm专题四1005
- CSS经典权重5道题解析
- HDU4821 String
- struts2详解
- OmegaT 扩展点滴
- Servlet
- 常见的浏览器兼容问题