SQL query from last 30 minutes
- skarbnik

- Nov 4, 2015
- 1 min read
SELECT top 1 [RECORD_ID]
,[UCID]
,[MODULE_NAME]
,[STARTDATETIME]
,[ANI]
,[PHONE_NUM]
,[DNIS]
,[CUST_LANG]
,[IVR_POINT]
,[EVENT_TYPE]
,[EVENT_VALUE_1]
,[EVENT_VALUE_2]
,[EVENT_VALUE_3]
,[EVENT_VALUE_4]
FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN]
where [STARTDATETIME] < GetDate() and [STARTDATETIME] > dateadd(minute, -30, GetDate())
--DATEDIFF(n,CAST([STARTDATETIME] as datetime),GETDATE())<=60
order by [STARTDATETIME]
desc

Comments