Greetings, I have a table:
TABLE A. with two columns:
PK dec, txt varchar2
The table has the following type of data
If you notice, the records can have A, B, C, or ALL with no constraints. If ALL exists, they should have A, B, C in the table as well (SEE PK's 1 and 8). Notice how PK 5 has ALL, but the A, B, nor C is in there. This happens in sporatic places throughout my table of over 100K records.
I need to write a query that finds the "PK 5's", or in other words the "ALL's" with no families. How do I locate them using SQL statement.