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 records have same id_1, but different id_2 and have
difference in time less than 5 minutes.

In this case this is record 1 and record 3.

How can I do this ?

Thanks in advance for your help.

Peter


                

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to