Posted By: JiMo (I'm flyiiiiiiing!!!!!!!!!) on 'CZdatabases'
Title:     Re: jeden kontrolni select
Date:      Mon Sep 11 19:05:53 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_ )


Mno nevim, mne na FB ta oracle-only rada zrejme chodi, narozdil od te prvni 
(casove) rady. Jen order by se musel prepsat na IDcka sloupcu.


                        JiMo:)

CONNECT 300^M .....OP^aFD)*HR!hT%UJ0~~!aS&RT&*WQ$*brI&FG^NO CARRIER

Search the boards