Re: [sqlite] group question

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

[sqlite] group question

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