Sehen so ORACLE-Tabellen aus? Schauder ...
falls ich deinen Wunsch richtig verstanden habe...Code:test=*# select distinct invoice from desktop except select invoice from desktop where sequence ~ 'fasel'; invoice --------- 2 (1 row) test=*# select * from desktop ; invoice | sequence ---------+---------- 1 | bla 1 | fasel 1 | blub 2 | bla 2 | blub (5 rows) test=*# select distinct invoice from desktop except select invoice from desktop where sequence ~ 'fasel'; invoice --------- 2 (1 row)
Andreas



LinkBack URL
About LinkBacks
Zitieren



Lesezeichen