Hi Jim Unfortunately I have thousands of such points. So explicit statement calling will be very expensive both computationally and in terms of writing..
Thanks, -Abhi On Fri, May 8, 2009 at 12:37 PM, Jim Lyons <jlyons4...@gmail.com> wrote: > why not something like below. Assume you have 3 pairs of start/end > timestamps and you want to find everything within those 3 time periods: > > select * from table_name where start >= start1 and end <= end1 > union > select * from table_name where start >= start2 and end <= end2 > union > select * from table_name where start >= start3 and end <= end3 > > > On Fri, May 8, 2009 at 11:26 AM, Abhishek Pratap > <abhishek....@gmail.com>wrote: > >> Hi All >> >> I am kind of stuck with this query , cant expand my thinking. May this is >> a >> limitation. Here it is >> >> I have a database with many cols two of which are start and end position >> for >> an event. >> >> Now I have a list of event time stamps, I want to find all the info once >> the >> current event time stamp is >= start time of event and <=end time of >> event. >> >> something like this >> >> select * from table_name where start <= ( LIST of time stamps) AND end >=( >> list of time stamps). >> >> Clearly above query accepts only one item in the list. Is there a way to >> do >> this for multiple items in the list ??? I can't think of anything at this >> moment. >> >> >> Thanks, >> -Abhi >> > > > > -- > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com >
