How to count particular date from records of table using sql select query

How to count particular date from records of table using sql select query.

SELECT DATE,COUNT(*)  FROM tblname  GROUP BY DATE

Group by clause will make record distinct as per date coulum and count function will show you total number of dates.

Comments