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!

How can I apply query for criteria?

583087Aug 29 2007 — edited Aug 29 2007

Please consider this table given below:-
CODE PLACE
A P1
A P2
B P1
C P2
D P1
D P2

Now I just want to retreive code which is only associating with place P1. I expect the result here to be B only.
How can I apply query here?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 26 2007

Added on Aug 29 2007

8 comments

4,690 views