June 5, 2012

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.

No comments:

Post a Comment