大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺
跃然一笑
MySQLSELECT FieldA , GROUP_CONCAT(FieldB ORDER BY FieldB SEPARATOR ‘,’) AS FieldBs FROM TableName GROUP BY FieldA ORDER BY FieldA;Oracle&DB2SELECT FieldA , LISTAGG(FieldB, ‘,’) WITHIN GROUP (ORDER BY FieldB) AS FieldBs FROM TableName GROUP BY FieldA ORDER BY FieldA;PostgreSQLSELECT FieldA , STRING_AGG(FieldB, ‘,’ ORDER BY FieldB) AS FieldBs FROM TableName GROUP BY FieldA ORDER BY FieldA;SQLServerSQLServer≥2017&Azure SQLSELECT FieldA , STRING_AGG(FieldB, ‘,’) WITHIN GROUP (ORDER BY FieldB) AS FieldBs FROM TableName GROUP BY FieldA ORDER BY FieldA;SQLServer≤2016(包括cte以鼓励干原理) WITH CTE_TableName AS (
SELECT FieldA, FieldB FROM TableName)SELECT t0.FieldA , STUFF((
SELECT ‘,’ + t1.FieldB FROM CTE_TableName t1 WHERE t1.FieldA = t0.FieldA
ORDER BY t1.FieldB FOR XML PATH(”)), 1, LEN(‘,’), ”)
AS FieldBs FROM CTE_TableName t0 GROUP BY t0.FieldA ORDER BY FieldA;SQLite排序需要CTE或子查询 WITH CTE_TableName AS (
SELECT FieldA, FieldB FROM TableName ORDER BY FieldA, FieldB)SELECT FieldA
, GROUP_CONCAT(FieldB, ‘,’) AS FieldBs FROM CTE_TableName GROUP BY FieldA ORDER BY FieldA;不订货SELECT FieldA , GROUP_CONCAT(FieldB, ‘,’) AS FieldBs FROM TableName GROUP BY FieldA ORDER BY FieldA;
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/197507.html原文链接：https://javaforall.net
