Find all records entered more then 10 min apart

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26986 More actions · Answer 1

select PK

from mytable

where Event='Sold'

group by PK

having datediff(minute,min(Eventime),max(Eventime))>10

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

Marcus Farrugia SSCarpal Tunnel Points: 4718 More actions · Answer 2

SSCarpal Tunnel

Points: 4718

February 25, 2009 at 12:06 pm

Thanks Mark, that's what i was looking for...