In envision what would be SQL Query to fetch last four hours Report from current time using the table NIC System

Discussion created by Ragunathan_M on Mar 13, 2013
Latest reply on Mar 16, 2013 by Ragunathan_M

Am trying to write a query and am success till the point I collect the total number of event Count(count) but unable to write a condition to fetch records written more that 250 times within a certain time frame (ie., from the current timestamp - 4 hours).... Unable to find the parameter for the same or the field to obtain the same.