A simple solution grouping? Perhaps?

[robdunfey]

I run to queries. The first query returns:

A
B
B
C

The second query returns:

A
A
B
B
C

I am trying to write a third query that compares results from query 1 & 2 to give:

B

Because if you match the results of 1 & 2 B is the letter that completely matches? I am new to Oracle but am quite bambozzled by this.

Rob

 

[bppbme]

<select statement 1> INTERSECT <select statement 2>, is one possibility. Take a look at the Oracle SQL Reference Manual for more info.

 

[carp]

No - this would give you
A
B
C

Rob - why doesn't C match in both queries (I assume by &quot;completely matches&quot; you mean the same number of occurrences; if this isn't the case, please explain what you really mean).

SELECT letter_column FROM
(SELECT col1 letter_column, count(*) rowcount
FROM table1
GROUP BY col1
INTERSECT
SELECT col1, count(*)
FROM table2
GROUP BY col1);

should give you what you're looking for.

 

[robdunfey]

bppbme,

Thanks for the reply. I had thought of the select statement but this did not work. I end up with:

ABBC which makes sense. How do I get just B?

 

[bppbme]

Whoops, wasn't paying attention to the example results. Sorry!