I am trying to look for id's, where for that ID, all the entries in the second column are duplicate and exist under one or more other id's. This means I am not simply looking for whether having (id2) => 2.

If this is the input.

```
id   id2    
 1    44          
 1    44      
 1    44      
 2    44      
 2    44          
 2    44    
 2    44
 2    46    
 3    42      
 3    44          
 3    44          
 4    55    
 4    55          
 4    55          
 4    55          

```

The output should be:

```
id   id2    
 1    44          
 1    44      
 1    44      

```

Because all the entries under id2 also exist in id #2. Id #3 is not in the output because only some of the entries match another id, the output should only give the entries where all the id2 entries match another, regardless of how many entries it has.

I am using MySQL Workbench.