Forum guidelines
AuthorQuestion
JAYRAM
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
Download Free eBooks

SPONSORED BY

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.