SELECT companyName,productType,SUM(quantity) from data_dustship WHERE 1 GROUP BY companyName,productType
group by 可以对列内容分组,如上语句,是我想要的结果,但是 companyname有重复值
请问如何写可以达到 companyName 不重复
SELECT companyName,productType,SUM(quantity) from data_dustship WHERE 1 GROUP BY companyName,productType
group by 可以对列内容分组,如上语句,是我想要的结果,但是 companyname有重复值
请问如何写可以达到 companyName 不重复