Select
DateAdd(minute, DateDiff(minute, 0, ModifiedOn), 0) AS [DAY_MINUTE], Count(*) AS [TOTAL_MINUTE]
,
Count(*) / 60.0 AS [TOTAL_SECOND]
From row2015_mscrm.dbo.contact (nolock)
where ModifiedOn > DATEADD(mi,(-120) -15,getdate()) --'2016-08-09 08:40:00.000'
Group By DateAdd(minute, DateDiff(minute, 0, ModifiedOn), 0)
order by 1 desc
