Segregating the data with awk

from employee table,need to segregate to their respective departments and to store in separate file,can any body help

???????
you need a database query ?
Or do you have the input file ?
how input file looks like ?
what output format you expect ?

I have input .txt file which contains the emp details..

how input file looks like ?
what output format you expect ?