Re: [sqlite] select ... where count(*)

2012-06-23 Thread giris
To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Saturday, June 23, 2012 1:21 PM Subject: Re: [sqlite] select ... where count(*) On Jun 23, 2012, at 7:19 PM, Patrik Nilsson wrote: > Great! This works better than mine suggestion. By the way… you might find

Re: [sqlite] select ... where count(*)

2012-06-23 Thread Petite Abeille
On Jun 23, 2012, at 7:19 PM, Patrik Nilsson wrote: > Great! This works better than mine suggestion. By the way… you might find the fine manual handy: http://www.sqlite.org/lang.html ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] select ... where count(*)

2012-06-23 Thread Patrik Nilsson
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

Re: [sqlite] select ... where count(*)

2012-06-23 Thread Petite Abeille
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] select ... where count(*)

2012-06-23 Thread Patrik Nilsson
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