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
- Edited by Navaraj subedi 11 minutes ago