Performing group by, Order by on a table starting from particular date to recent last date
You just need to add a WHERE clause in the statement, like: where Date &gt;= '2016-03-05': 

select v.Date, count(v.id) as co 
from volunter as v
where v.Date &gt;= '2016-03-05'
group by v.Date 
order by v.Date ;



Details may differ depending on the DBMS you use. For SQL Server for example, the safe format for the date and datetime types is 'YYYYMMDD', so it would be better to write the where as where v.Date &gt;= '20160305'. In Oracle and Postgres you could use where v.Date &gt;= DATE '2016-03-05'.
Date is a reserved keyword in some DBMS, so it would be better to choose another name for that column. Or always prefix it with the table name/alias.