Oracle SQL Query Question

Question

I have the following table setup in an oracle database:

Column Pk_foo1
Column Pk_foo2
Column Pk_foo3

How do I select the rows that are not unique if it were the case that Pk_foo1 and Pk_foo2 were the only primary keys.

An example of a select query would be appreciated. Thanks!

Tony · Accepted Answer · 2010-11-22 15:22:42Z

4

SELECT Pk_foo1, Pk_foo2
FROM Table
GROUP BY Pk_foo1, Pk_foo2
HAVING COUNT(*) > 1

answered Nov 22, 2010 at 15:22

Tony

10.4k3 gold badges51 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1