因此,我有一个表,其中我想要客户是麦当劳且日期> 2019-06-30的行数
我在努力
select "Customer",
Count("Customer")
FROM
public.master_environmental_data
WHERE "Customer" = 'McDonald''s' AND "Date" > '2021-06-30';然而,我得到了这个错误:
column "master_environmental_data.Customer" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select "Customer",
^
SQL state: 42803
Character: 8什么是正确的查询?
发布于 2021-08-17 04:28:15
应该在查询的末尾添加一个GROUP BY:
select "Customer",
Count("Customer")
FROM
public.master_environmental_data
WHERE "Customer" = 'McDonald''s' AND "Date" > '2021-06-30'
GROUP BY "Customer";https://stackoverflow.com/questions/68811603
复制相似问题