I have two tables eno and eid in my emp table. I have inserted some values where eno is a primary key. So, the table looks like this

eno eid

---- ----

1 1

2 1

3 2

4 2

5 2

6 3

7 3

8 3

9 4

10 4

In eid column 1,2,3,4 is repeated several times.

I want from eid where data is 2 and 3 because it is repeated 3 times. I just want two rows from eno column either 3 or 4, 4 or 5, 3 or 5 and similarly for eid column with 3 i want 6 or 7, 7 or 8, 6 or 8. I just want only two times repetition of 2 and 3 in my result table

My result should look like

eno eid

---- ----

3 2

4 2

6 3

8 3

Could you please help me out.