i have table like this MOBILE NAME 9849313820 RAJU 9849313820 VAMSHI 9949858757 SRINIVAS 9949858757 VENKAT REDDY 9849313820 RAVI NULL NULL I WANT OUTPUT LIKE THIS....... MOBILE NAME 9849313820 RAJU 9949858757 SRINIVAS

ihave 1000 rows ....... display fist distinct mobile , name coloum value

select DISTINCT * from emp1 where NAME in('RAJU','SRINIVAS')