Forum guidelines
AuthorQuestion
DISPLAY DISTINCT MOBILE AND SINGLE NAME
Posted 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 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 on: 10 Apr 2013  
ihave 1000 rows .......

display fist distinct mobile , name coloum value

v
Employers - Post Free Jobs

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.