from sql*plus:
WITH summary AS
(SELECT an_id FROM author_zipcode_dupes)
SELECT an_id FROM author_zipcode MINUS SELECT an_id FROM summary;
WITH clause increases performance.
F.
|
Results 1 to 6 of 6
Threaded View
|
Click Here to Expand Forum to Full Width |