On 10/18/2014 10:30 PM, ye yanhong wrote:
select count(scode) as bb,scode from mytb where trues=1 and bb=3 group by
scode;
Error: misuse of aggregate: count()
You are trying to use (indirectly, via bb alias) an aggregate function
in a WHERE clause. You can't. WHERE clause specifies conditi
select count(scode) as bb,scode from mytb where trues=1 and bb=3 group by
scode;
Error: misuse of aggregate: count()
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2 matches
Mail list logo