Selecting multiple occurence on a table

MMM · #1 (**permalink**) 06-15-2008, 07:45 PM

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

#2 (**permalink**) 06-16-2008, 11:38 AM

SELECT e.column1,e.column2 

FROM table_name e ,table_name f 

WHERE e.column1=f.column1 AND e.column2=f.column2

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password

Selecting multiple occurence on a table

ANSWER(S):