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