count row after select statement

[mixupatel]

SELECT attnddate, COUNT(1)as v_cnt    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;

output:-

ATTNDDATE V_CNT 
02-01-2011 2 
03-01-2011 1 
01-01-2011 3 

hey this is my query and now i want to count the row of v_cnt so plz help me

[yarbrough40]

I think you mean you want to count the number of rows (records). Use a subquery

SELECT COUNT(v_cnt) FROM(
SELECT attnddate, COUNT(1)as v_cnt    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)sq