I have a table like as follws
Emp_id, first_login , second_login 1 02/10/09 04/11/09 2 03/10/09 04/11/09 3 04/10/09 05/11/09 4 05/10/09 06/11/09 5 06/10/09 ------------ 2 06/10/09 ------------ 4 07/10/09 ------------ 6 ------------ ------------ 3 ------------ ------------ 1 ------------ ------------ 9 ------------- ------------ 7 ------------ ------------ 8 ------------ ------------ >From this I need a table like Month, First_total(count(emp_id)), second_total(count(emp_id)) In first and second login the employee id will be consider only one time.. Please help me for this. thanks in advance