Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
select distinct mobile ,firstname
JAYRAM
Apr 25 2013 8:43 AM
1.3k
Reply
i have table like this....................
SNO MOBILE NAME
1
8987654321
RAJUVARDHAN
2 8987654321 PRANAYE KUMAR
3 8987854321 VAMSHIDHAR
4
9014494875
SHASHI
5 9014494875 SUVARNA VARMA
6 9014494875 MEENAREDDY
7
9866029162
JANSIVARMA
8 9866029162 PRAGATHIVARMA
9 9866029162 SAMBA VARMA
I Want output like this...
select distint mobile and first name only
like this
SNO MOBILE NAME
1 8987654321 RAJUVARDHAN
4 9014494875 SHASHI
7 9866029162 JANSIVARMA
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
HOW TO SELECT DISTINCT MOBILE AND FIRST NAME ONLY
Auto Backup In SQL Server 2008R2