i have a table T1 which has two columns
every emp must be in 37 department , but there are some employee who are in less than 37 department .
I need to find the names of emp who are not in all 37 departments.
i'm using a query :
select empname from T1 having count (department) < 37;
but it is not giving me the desired output.