top of page

SQL query from last hour

  • Writer: skarbnik
    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


Search By Tags
bottom of page