Forum guidelines
AuthorQuestion
DISPLAY DISTINCT MOBILE AND SINGLE NAME
Posted By JAYRAM on 10 Apr 2013
i have table like this 
MOBILE          NAME 
9849313820RAJU
9849313820VAMSHI
9949858757SRINIVAS
9949858757VENKAT REDDY
9849313820RAVI
NULLNULL

I WANT OUTPUT LIKE THIS.......
MOBILE              NAME
9849313820      RAJU
9949858757      SRINIVAS


v
AuthorReply
Re: DISPLAY DISTINCT MOBILE AND SINGLE NAME
Posted By Satyapriya Nayak on 10 Apr 2013  
select DISTINCT * from emp1 where NAME in('RAJU','SRINIVAS')

If this post helps you mark it as answer
Thanks

Re: DISPLAY DISTINCT MOBILE AND SINGLE NAME
Posted By JAYRAM on 10 Apr 2013  
ihave 1000 rows .......

display fist distinct mobile , name coloum value

v
Spire.Doc

SPONSORED BY

JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.