Postgresql Gourp by 多字段问题
SELECT
id,
create_time,
platform_id,
channel_id,
sum(active_count) AS active_count,
sum(install_count) AS install_count,
sum(open_count) AS open_count
FROM market_stats_remain
WHERE
channel_id=100
AND create_time
BETWEEN 1427817600 AND 1430409600
GROUP BY id, create_time, platform_id, channel_id LIMIT 12 OFFSET 0
以上的SQL语句是正确的,但是必须GROUP BY 在SELECT 部分出现的全部字段否则就报错
比如
SELECT
id,
create_time
FROM market_stats_remain
GROUP BY create_time
报错,因为select部分有ID,而group by 部分没有
不知道这个是什么原因,求指教