say:
DEPT1 EMP1
DEPT1 EMP2
DEPT1 EMP3
DEPT2 EMP4
DEPT2 EMP5
DEPT3 EMP6
DEPT3 EMP7
....
....
....

if I want to group the rows by dept, do I have to select dept1 and group
them, and select dept2 and group... for every dept?

any better ideas?