How to reduce the record on the basis of Time if the minimum 2 minutes  duration in SQL Server 2014

I have a table with following data

(Id, date ,time)

11 2015/8/1 12:20:00

11 2015/8/1 12:21:00

11 2015/8/1 18:05:20

12 2015/8/1 11:20:00

12 2015/8/1 11:21:00

12 2015/8/1 18:10:20

I need the table with following record only

(Id, date ,time)

11 2015/8/1 12:20:00

11 2015/8/1 18:05:20

12 2015/8/1 11:20:00

12 2015/8/1 18:10:20

Any suggestion from anywhere will help me 



September 8th, 2015 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics