Jump to content

Find In-Between records


shakti_wonder

Recommended Posts

My Scenario:

I have a table with columns oid, did (ignore other columns i have)

I have records as:

 

oid did

== ===

10 20

20 35

35 54

54 15

 

10 18

25 65

 

 

10 19

19 15

 

If the records in my table are like this, then the query should return me

all records with oid=10 and eventually ending up in did = 15 and also n.did=(n+1).oid

 

Inputs would be oid = 10 and did = 17.

 

Thanx in advance.

Link to comment
https://forums.phpfreaks.com/topic/192894-find-in-between-records/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.