level 1
longing33
楼主
sql语句如下，求教怎么转成Django的ORM形式？
select date, column_2, sum(cnt) from table_a where date like '20180123%' group by date, column_2
我现在是这样写的：
Table_a.objects.filter(date__startswith=date).values('date', 'column_2').annotate(count=Sum('cnt'))
报错，Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'projects_a.tabe_a.date' which is not functionally dependent on columns in GROUP BY clause
我看官方文档里只写了一个字段的聚合，以及values()函数可以跟多个字段，没有写多个字段怎么聚合啊，求教这怎么写，要疯了
2018年01月23日 10点01分
1
select date, column_2, sum(cnt) from table_a where date like '20180123%' group by date, column_2
我现在是这样写的：
Table_a.objects.filter(date__startswith=date).values('date', 'column_2').annotate(count=Sum('cnt'))
报错，Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'projects_a.tabe_a.date' which is not functionally dependent on columns in GROUP BY clause
我看官方文档里只写了一个字段的聚合，以及values()函数可以跟多个字段，没有写多个字段怎么聚合啊，求教这怎么写，要疯了