n" <[EMAIL PROTECTED]>
> To: "Bruce Feist" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, 11 July, 2003 22:16
> Subject: Re: Request modelling
>
> 2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> > Hi Bruce;
> >
>
<[EMAIL PROTECTED]>
To: "Bruce Feist" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, 11 July, 2003 22:16
Subject: Re: Request modelling
2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> Hi Bruce;
>
> Thank you for the reply.
>
> I passed the core
Hi Bruce,
Thank you for the reply.
Just for the record the options order must be
SELECT schedule_id,count(schedule_id)
FROM attendance
GROUP BY schedule_id
HAVING count(schedule_id) <10;
(swapped GROUP BY and HAVING)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 10:20、Bruce Fe
Hi Bruce;
Thank you for the reply.
I passed the core exam but obviously its not enough ;-) Live and learn ;-)
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 t
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 woul
Hi John,
Thank you for the reponse. I tried that (I didnt post it here), but that gives
me the error
mysql> SELECT schedule_id,count(schedule_id) AS ct FROM attendance WHERE ct<10
GROUP BY schedule_id ;
ERROR 1054: Unknown column 'ct' in 'where clause'
Best regards
Nils Valentin
Tokyo/Japan
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)
On Fri, 2003-07-11 at 13:41, Nils Valentin wrote:
> Hi MySQL Fans ;-)
>
> 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 sche
Hi MySQL Fans ;-)
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)<1
