MySQL query: Single Table multiple comparisions
===

I have the following mysql table:

id     |  member     |

|  1      |  abc |       
| 1       |  pqr |   
| 2 | xyz  |  
| 3  | pqr  |  
| 3 | abc |  
  
I have been trying to write a query which would return the id which has exact same members as a given id. For example, if given id is 1 then the query should return 3 because both id 1 and id 3 have exact same members viz. {abc, pqr}. Any pointers? Appreciate it.

  


 

