Data Count in Sql Server

Hanook12y ago

select COUNT(*) as 'Data Count' , Cast ( DateColumn aS DATE) DateColumn
from TableName
group by Cast ( DateColumn aS DATE)

depends on DateColumn.. if that is DATETIME type convert it to DATE and then apply GROUP BY....

Girish Sapariya12y ago

Hi Arjun this will give u total count of records as per the date,try it and let us know

select COUNT(*) from TableName where dateColumn = '2014-11-07'
date format for sql server = YYYY-MM-DD

Jaganathan Bantheswaran12y ago

Try something like this,

select COUNT(*) as 'Data Row Count', ShippedDate from Orders group by ShippedDate