Wednesday, July 2, 2014

Retrieve one row from multiple similar values column

So, i have Following table records with repeated name with different emails -












































EmailDirc



EmailID



Ename



Edob



harish123@gmail.com



Harish Salve



15-10-1989



navink87@hotmail.com



Navin Keddy



17-02-1987



harish124@gmail.com



Harish Salve



15-10-1989



navink87@live.com



Navin Keddy



17-02-1987



harish125@gmail.com



Harish Salve



15-10-1989



harish126@gmail.com



Harish Salve



15-10-1989



and now i want to retrieve rows on behalf of Ename like following -
























EmailDirc



EmailID



Ename



Edob



harish123@gmail.com



Harish Salve



15-10-1989



navink87@hotmail.com



Navin Keddy



17-02-1987



kindly put some light to accomplish below required goal, thanks in advance.


No comments:

Post a Comment