Posted By: dzemen () on 'CZdatabases'
Title:     Re: jeden kontrolni select
Date:      Fri Sep  8 14:42:49 2006

> Pokud Ti nevadi, ze to pripadne prekryvy vypise vickrat, tak muzes pouzit 
> tohle :
> select * from prekryv a, prekryv b
> where a.id=b.id and not a.rowid=b.rowid
> and ((b.od between a.od and a.do) or (b.do between a.od and a.do))
> order by 1,2,3

Grrrr!!!! Uz zase jedna Oracle-only rada ! :-(((

To ten:

select t.id from rv_proh_xml t where
  exists (
   select id from rv_proh_xml a where a.from_ between t.from_ and t.to_
    or a.to_ between t.from_  and t.to_ )

bude aspon fungovat vsude (SQL92 kompatibilni). Mimochode tusim Jimo se tu 
ptal, co je to to "t" na 1. radce vyrazu a "a" ve 3. radce. Tak to jsou aliasy 
te tabulky rv_proh_xml (jde o to, ze je v tom dotazu pouzita 2x a musi se to 
nejak odlisit....) 

Dzemen