title: SQL server query for selecting data with 5 seconds interval
body: <p>Can anyone tell me T-SQL script for selecting data with the interval of 5 seconds? I have a SCADA system which logs data for a parameter every second but i want to retrieve data with interval of 5 sec, also the start time will be decided by user.
  Example if start = 10:00:01 and end is 11:00:00 I want to see data at 10:00:06, 10:00:11, 10:00:16... but not data at 10:00:02, 10:00:03 to 10:00:05, and between 10:00:07 and 10:00:10</p>