For example, I have a table with a schema

CREATE TABLE #Test {

EmployeeID Int,

LogTime DateTime

}

INSERT INTO #Test

(1001, '01/01/2010 10:22:36'

1002, '01/01/2010 10:24:37'

1003, '01/01/2010 10:24:38'

1001, '01/01/2010 10:24:39'

1001, '01/01/2010 10:24:40'

1002, '01/01/2010 10:24:45'

1003, '01/01/2010 10:26:45'

)

While selecting data from the above table with the sample records, I want the output to appear like,

Output

1001, '01/01/2010 10:22:36'

1002, '01/01/2010 10:24:37'

1003, '01/01/2010 10:24:38'

1003, '01/01/2010 10:26:45'

Thus, rejecting all the duplicate times within 01 Minute period

Thanks