Say I have sqlite table with the following records:

recID | productID | productName

1 | 1 | Product A

2 | 2 | Product B

3 | 2 | Product C

4 | 3 | Product D

5 | 3 | Product D

recID = primary key, auto increment.

If I run: SELECT productID, productName FROM table GROUP BY productID, productName

Result is:

1 | Product A

2 | Product B

2 | Product C

3 | Product D

As you can see, productID 2 has inconsistent productName: Product B and Product C. How do I run query just to detect the inconsistent ones? Eg I want the result to be:

2 | Product B

2 | Product C