Posted By: JiMo (I'm flyiiiiiiing!!!!!!!!!) on 'CZdatabases'
Title:     Re: jeden kontrolni select
Date:      Mon Sep 11 19:38:00 2006

Yabadabadoooooooooo! :)))

Tak tedy to "oracle-only" reseni vesele beha, tedy v uprave 

select * from TABULKA A, TABULKA B
 where A.ID=B.ID and not A.IDT=B.IDT
 and ((B.OD > A.OD and B.OD < A.DO) or (B.DO > A.OD and B.DO < A.DO))
 order by A.ID
;

Musim rict, ze to na pomerne vykonnem serveru chroustalo pres pet minut,
ale je to ono! 
Dekuji, dekuji... pokud se mi podari dotvorit ten prvni tvar (s exist),
muzu dat vedet, co je efektivnejsi. :)


                        JiMo:)

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

Search the boards