On 06/18/2014 04:47 PM, Jason Long wrote:
I have a large table of access logs to an application.
I want is to find all rows that overlap startdate and enddate with any
other rows.
The query below seems to work, but does not finish unless I specify a
single id.
select distinct a1.id
from t_acce
On 19 Jun 2014, at 1:47, Jason Long wrote:
> I have a large table of access logs to an application.
>
> I want is to find all rows that overlap startdate and enddate with any
> other rows.
>
> The query below seems to work, but does not finish unless I specify a
> single id.
>
> select dis
On Wed, 2014-06-18 at 18:08 -0600, Rob Sargent wrote:
> On 06/18/2014 05:47 PM, Jason Long wrote:
>
>
> > I have a large table of access logs to an application.
> >
> > I want is to find all rows that overlap startdate and enddate with any
> > other rows.
> >
> > The query below seems to wo
On 06/18/2014 05:47 PM, Jason Long wrote:
I have a large table of access logs to an application.
I want is to find all rows that overlap startdate and enddate with any
other rows.
The query below seems to work, but does not finish unless I specify a
single id.
select distinct a1.id
from t_acce
I have a large table of access logs to an application.
I want is to find all rows that overlap startdate and enddate with any
other rows.
The query below seems to work, but does not finish unless I specify a
single id.
select distinct a1.id
from t_access a1,
t_access a2
where tstzr
