SQL Join with count
- skarbnik
- Nov 4, 2015
- 1 min read
SELECT fromaddress, Record_Count=Count(*)
FROM [ASMSData1].[dbo].[Interactions] as interact
JOIN
[ASMSData1].[dbo].[Sectors] AS secto
ON interact.InteractionId = secto.InteractionId
where
CreateDateTime between '2015-08-01' and '2015-08-31'
GROUP BY fromaddress
Comments