Zeoslib Portal

Posted: **18.09.2007, 16:58**

Hi,

First, I'd like to thank the authors of sqlite administrator for making their software publicly available for free.

I also write this message to let you know that the "having" keyword is not syntax-highlighted in the SQL editor. I suppose it should be.

(I am using 0.8.3.1 public beta)

Rémi

Posted: **19.09.2007, 07:08**

Iam not sure how to use the "having" keyword but i will consider this in the next version

Posted: **19.09.2007, 07:33**

Orbmu2k wrote:Iam not sure how to use the "having" keyword but i will consider this in the next version

Thanks. "having" is a kind if "where" that filters results after "group by":

Code: Select all

select poster_id, count(message_id)
from who_posted_what
group by poster_id
having count(message_id) > 2

Rémi

Posted: **19.09.2007, 07:41**

very nice ... ive wished me something like this a lot of times

Zeoslib Portal

"having" keyword not syntax highlighted

"having" keyword not syntax highlighted