Performing a WITH ROLLUP when grouping by multiple fields, MySQL returns a rollup row for each group, as well as the overall summary:
CREATE TABLE test (name VARCHAR(50), number TINYINT);
INSERT INTO ...

i have a table T1 which has two columns empname , department
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 ...