Re: Request modelling

[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



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