2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> Hi Bruce;
>
> Thank you for the reply.
>
> I passed the core exam but obviously its not enough ;-) Live and learn ;-)

Aeeh thats was supposed to be ... life and learn..
Perhaps somebody knows a good spellchecker for logical mistakes ?? ;-)
That would have immediately popped up on my screen ;-)
 

Best regards

Nils Valentin
Tokyo/Japan


>
> Thank you very much for the reply.
>
> Best regards
>
> Nils Valentin
>
> 2003年 7月 12日 土曜日 10:20、Bruce Feist さんは書きました:
> > Nils Valentin wrote:
> > >I would like to list all courses with have less than lets say 10
> > > participants. Does anybody know how I would have to modify the code
> > > below to get this to work ?
> > >
> > >schedule_id is the course itself
> > >
> > >
> > >SELECT schedule_id,count(schedule_id) FROM attendance WHERE
> > >count(schedule_id)<10 GROUP BY schedule_id ;
> > >
> > >My problem is that I would need to use the count function actually
> > > within the WHERE (clause which is not allowed).
> >
> > That's precisely why HAVING exists.
> >
> > SELECT schedule_id,count(schedule_id)
> > FROM attendance
> > HAVING count(schedule_id) <10
> > GROUP BY schedule_id ;
> >
> > Bruce Feist

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to