Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL to find a range within a range

Re: SQL to find a range within a range

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 14 Sep 2006 12:04:21 -0700
Message-ID: <1158260661.524081.263610@b28g2000cwb.googlegroups.com>

How about ...
where members.start <= our_end

and members.end >= Our_start
? Received on Thu Sep 14 2006 - 14:04:21 CDT

This message: [ Message body ]
Next message: Ed Prochak: "Re: SQL to find a range within a range"
Previous message: bay_dar_at_yahoo.com: "SQL to find a range within a range"
In reply to: bay_dar_at_yahoo.com: "SQL to find a range within a range"
Next in thread: Ed Prochak: "Re: SQL to find a range within a range"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US