I have a table with the following data:
Code:
TableA
Column1 Column2
1 1
1 4
1 12
2 1
2 1
2 3
3 1
3 4
4 2
4 6
4 8
4 11
4 13
I am trying to create a query that would return all rows that has multiple occurence in column2 and column1 i.e. Column1 = 2 and Column2 =1 because 2,1 is in the table twice.
The result would be:
Code:
Column1 Column2
2 1
2 1