Great! This works better than mine suggestion. /Patrik On 06/23/2012 07:12 PM, Petite Abeille wrote: > > On Jun 23, 2012, at 6:55 PM, Patrik Nilsson wrote: > >> select id,count(*) from repetitionhistory where count(id)<3 group by id > > select id,count(*) from repetitionhistory group by id having count(id)<3 > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users