Hi All, I want to write a statement like: (gives error on "count", misuse of aggregate: count())
select id,count(*) from repetitionhistory where count(id)<3 group by id This statement works when written without "where": select id,count(*) from repetitionhistory group by id But I'm only interested in those not being used many times. Best regards, Patrik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users