[Hsqldb-user] Having clause

[Andrew B. <an...@ex...>]

In M$SQL Server, theres a having clause.  I was wondering if there is a 
similar functionality I could use in hsqld.

Here's what I'm trying to do.  If I have a table of employees in a 
department, I want to return only the departments with more than 5 
employees.  In M$SQL this would be:

SELECT department_id, count(*) as employee_count
FROM employee_department
GROUP BY department_id
HAVING count(*) > 5

Thanks in advance,
Andy