hey this my query
and ouput is
ATTNDDATE COUNT(1)
02-01-2011 2
03-01-2011 1
01-01-2011 3
now i want to find total attnddate of 1 employe and same date will count only 1 time
Code:
SELECT attnddate, COUNT(1)
FROM inouttime where empcode='1' and to_date(attnddate,'DD-MM-YYYY') between to_date('01-01-2011','DD-MM-YYYY') and to_date('07-01-2011','DD-MM-YYYY')
group by attnddate;
ATTNDDATE COUNT(1)
02-01-2011 2
03-01-2011 1
01-01-2011 3
now i want to find total attnddate of 1 employe and same date will count only 1 time
Comment