Thanks for All the help, I appreciate all the input. Helped greatly...

Thank You

Here is what i came up with however I had to create a tmp table and join back to get both records.

SELECT

Divice_time

, Unit

, COUNT(DISTINCT Fill_time) AS cnt

FROM

Table

GROUP BY

Divice_time

, Unit

HAVING

COUNT(DISTINCT Fill_time) > 1