Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Record count of the coulmn field RE: Record count of the coulmn field
cbrammer1219
SSCarpal Tunnel
Points: 4476
More actions
October 30, 2014 at 9:19 am
#1755820
DECLARE @startdate datetime
declare @enddate datetime
set @enddate = '10/1/2014'
SET @startdate = '10/11/2014'
select field1,field2,COUNT(FIELD3) from TABLE where date between @startdate and @enddate group by field1,field2