i used this script .. but not works
select Count(*) , date_Col
from table
Where date_col between '1/1/2000' and '1/2/2003'
Error : group by need to be used ..
changed to
select Count(*) , date_Col
from table
Where date_col between '1/1/2000' and '1/2/2003'
group by date_col
not working ..
please tell me ..How to Get the number of records and date colum ..
between specific columns
\