我有一个表,我想选择一些行并按日期对它们进行分组。问题是when i'm selecting within my select that row appear to not grouped by date,参见示例:user = 'Catherine') as cprice FROM expense GROUPBY date
它不分组c
我有一个包含字段数量的表日志,我需要得到按日分组的金额和月份的总和的日期。我需要将sqlite代码迁移到postgresql,但我发现代码迁移类型为hard.The sqlite,如下所示
SELECT SUM(amount),transaction_date FROM logWHERE user_id = 1 AND strftime('%Y', transaction_date) = '2019' GROUP BY strftime('