SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Opposite to UNION

432653Nov 10 2004 — edited Nov 11 2004

Hi!

I have two queries. First gives me 10 rows and the other 3

1. select customer_id, customer_name from t_cust (10 rows)
2. select distinct customer_id, customer_name from t_cust (3 rows)

And I want to subtract resultset 2 from 1 and get 7 rows that are not in the first query.

Regards!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2004

Added on Nov 10 2004

6 comments

386 views