大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺
我在Orcle里写了一个Sql语句，用到了LISTAGG，现在要改成mysql数据库，我要怎么改这个Sql语句？SELECTA.GUID,A.COMPANY_GUID,A.GOODS_CODE,A.GOODS_NAME,A.SPECIFICATIONS,A.SMALL_IM…
我在Orcle里写了一个Sql语句，用到了LISTAGG，现在要改成mysql数据库，我要怎么改这个Sql语句？
SELECT A.GUID,A.COMPANY_GUID,A.GOODS_CODE,A.GOODS_NAME,A.SPECIFICATIONS,A.SMALL_IMAGE,A.GOODS_UNIT_GUID,A.STATE,A.MARKET_VALUE,A.INTRODUCE,A.INVENTORY,A.ALARM,A.IAMGE_PATH,A.IS_LOSE,A.CREATE_TIME,A.CREATE_USER,A.MODIFY_TIME,A.MODIFY_USER,U.UNIT_NAME AS GOODS_UNIT_NAME
,LISTAGG(B.GUID,”’,”’) WITHIN GROUP (ORDER BY B.GUID) AS GOODS_TYPE_GUID
FROM B1_GOODS A
LEFT JOIN B1_UNIT U ON U.GUID = A.GOODS_UNIT_GUID
LEFT JOIN B1_GOODS_TYPE_RELATION T ON A.GUID = T.GOODS_GUID
LEFT JOIN B1_GOODS_TYPE B ON T.GOODS_TYPE_GUID = B.GUID
WHERE 1=1
GROUP BY A.GUID,A.COMPANY_GUID,A.GOODS_CODE,A.GOODS_NAME,A.SPECIFICATIONS,A.SMALL_IMAGE,A.GOODS_UNIT_GUID,A.STATE,A.MARKET_VALUE,A.INTRODUCE,A.INVENTORY,A.ALARM,A.IAMGE_PATH,A.IS_LOSE,A.CREATE_TIME,A.CREATE_USER,A.MODIFY_TIME,A.MODIFY_USER,U.UNIT_NAME
ORDER BY A.GUID
展开
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/196601.html原文链接：https://javaforall.net
