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

Question

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项

Answer 1

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