List:General Discussion« Previous MessageNext Message »
From:Peter Date:October 17 2006 6:49pm
Subject:sql query
View as plain text  
Hello,

Lets suppose I have a table like this one

id id_1 id_2 date_time
1 101 1000 2006-07-04 11:25:43
2 102 1001 2006-07-04 11:26:43
3 101 1005 2006-07-04 11:27:43
4 103 1000 2006-07-04 11:25:43

I want to find all id_2 that has same id_1 and time difference in
records is no more than 5 minutes ...

I hope I explain well

In this case this is record 1 and record 3.

How can I do this ?

Thanks in advance for your help.

Peter
Send instant messages to your online friends http://uk.messenger.yahoo.com 
Thread
sql queryPeter17 Oct
  • Re: sql queryDan Buettner17 Oct
    • Re: sql queryRolando Edwards17 Oct
      • Re: sql queryPeter17 Oct
  • Re: sql queryPeter Brawley17 Oct