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!

sql

52207Feb 5 2007 — edited Feb 6 2007

scenario where need to find records where a particular id has 2 rows for code='X' and one row for code='Y' combined together.

So from the following data, only id 1 should be returned.

ID CODE
-------
1 X
1 X
1 Y

2 X
2 Y

3 X
3 X
3 Y
3 Y

4 X
4 X

5 Y
5 Y

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2007

Added on Feb 5 2007

8 comments

2,188 views