I have a table as below
ID Username GroupID
1 venkat 2
2 venkat 3
3 ramu 1
4 ramu 2
Using the sql statement I want to retrieve all username's that are available in both the groupids 2,3
In this case only Venkat is the username that's available in both groupid 2 and 3
Kindly help me