Jia_Li_z 2019-04-17 15:21 采纳率: 50%
浏览 4093
已采纳

达梦数据库的group by 语句出错

SELECT  shop.ID AS 主键,shop.UID AS 用户ID,test.NAME AS 姓名  FROM sysdba.T shop 
LEFT JOIN sysdba.TEST test ON shop.ID = test.ID
WHERE shop.ID > 0
GROUP BY test.NAME;

加上group by 就报错 :无效的SELECT项

  • 写回答

2条回答 默认 最新

  • ꧁gaoKuo꧂ 2019-04-17 15:42
    关注

    SELECT max(shop.ID) AS 主键,max(shop.UID) AS 用户ID,test.NAME AS 姓名 FROM sysdba.T shop
    LEFT JOIN sysdba.TEST test ON shop.ID = test.ID
    WHERE shop.ID > 0
    GROUP BY test.NAME;
    或者
    SELECT shop.ID AS 主键,shop.UID AS 用户ID,test.NAME AS 姓名 FROM sysdba.T shop
    LEFT JOIN sysdba.TEST test ON shop.ID = test.ID
    WHERE shop.ID > 0
    GROUP BY test.NAME,shop.ID,shop.UID

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？