拼接列字段
- MySql
SELECT
`name`,
GROUP_CONCAT(course, ":", score) AS 成绩
FROM
student
GROUP BY
`name`;
- Oracle
select concat(字段) from 表
- sqlServer
select( select CAST(字段 as varchar)+','
from 表 where 条件 for xml path('') ) as A
SELECT
`name`,
GROUP_CONCAT(course, ":", score) AS 成绩
FROM
student
GROUP BY
`name`;
select concat(字段) from 表
select( select CAST(字段 as varchar)+','
from 表 where 条件 for xml path('') ) as A