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
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
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
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
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
5 matches
Mail list logo