Question

There is a table (employee), which has a column with an identity of a department (department_id).
Select list of departments where the count of employees less than 3.

Cosmo · Accepted Answer

select department_id from employee group by department_id having count(*) <= 3

Cosmo · Answer

select department_id from employee where count(department_id) <= 3

Cosmo · Answer

select department_id from employee where max(*) <= 3

Follow CodeGalaxy

Mobile Beta