SQL query from last hour
- 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 >= DATEADD(HOUR, -1, GETDATE())
GROUP BY fromaddress
order by Record_Count desc

Comments