Re: [sqlite] What is a Group By, having clause?

Hi Christophe, On 12/9/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > the difference between a normal "where"-clause and the "Group by", and > "having" I used www.sqlcourse.com and sqlcourse2.com probably in the year 2000. They had very good tutorials and also let your actually practice the

Re: [sqlite] What is a Group By, having clause?

> Think of HAVING as being analogous to WHERE. While WHERE applies to > the TABLE, HAVING applies to the results of GROUP. Here is a contrive yes, thank you. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf -

Re: [sqlite] What is a Group By, having clause?

[EMAIL PROTECTED] wrote: > http://www.w3schools.com/sql/default.asp > Thanks! That is great! -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] What is a Group By, having clause?

On 12/9/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > Hi, > > can someone point me to some docs where the difference between a normal > "where"-clause and the "Group by", and "having" statements are being > explained? > Think of HAVING as being analogous to WHERE. While WHERE applies to

Re: [sqlite] What is a Group By, having clause?

http://www.w3schools.com/sql/default.asp RBS > Hi, > > can someone point me to some docs where the difference between a normal > "where"-clause and the "Group by", and "having" statements are being > explained? > > I don´t quite understand what these are actually good for. > > Thanks, > > -- >

[sqlite] What is a Group By, having clause?

Hi, can someone point me to some docs where the difference between a normal "where"-clause and the "Group by", and "having" statements are being explained? I don´t quite understand what these are actually good for. Thanks, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED]