How to find unique values without using distinct function in SQL Server ? - Sajha Mobile
SAJHA MOBILE
How to find unique values without using distinct function in SQL Server ?
Posts 6 · Viewed 8136 · Go to Last Post
phone
· Snapshot 0
Like · Likedby · 0
I have a table with multiple duplicate values.
It has 2 columns: FirstName and LastName .
Now I want to select only unique values without using Distinct function.
Please help.

Thanks
Lee_St
· Snapshot 24
Like · Liked by · 0
You could use Group by or Union, something like below

Select FirstName, LastName, count(*) as Count
from Name
Group by FirstName, LastName
Having Count(*) = 1
phone
· Snapshot 148
Like · Liked by · 0
Thank you Lee_St

Almost close but I need 1 unique value from the duplicate value as well.
For example:-
FirstName LastName
A B
A B
In this case I need the answer only 1 FirstName A and LastName B
Using above query removes both A and B.
master_sajha
· Snapshot 230
Like · Liked by · 0
Select FirstName, LastName
from Name
Group by FirstName, LastName
STUPIDA
· Snapshot 237
Like · Liked by · 0
Do not use having clause.
28th amendment
· Snapshot 410
Like · Liked by · 0
ROW_NUMBER??
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor from US is reading How to find unique values without using distinct function in
Visitor from US is reading Stocks 2021!
Visitor from US is reading AOTC
Visitor is reading What is your feeling about this??
Visitor is reading Request for Initial Evidence I-485 Birth certificate
Visitor is reading Wish you were here
Visitor from US is reading new F-1 visa
Visitor is reading चटामरी बनाउन जान्ने कोहि हुनु हुन्छ ?
Visitor from US is reading sabai thok xa ma sanga ta ..
You might like these other discussions...
wakeyour_mind
These Student Protests Against Israel Are the Most Important Political Movement of Our Lifetime
· Posts 1 · Viewed 70
Lucky_Nepali » nash24
TPS advance parole Travel document i-131, Class of Admission ?
· Posts 2 · Viewed 254
Smriti-malla
मरेर गएनि कहिल्यै नमर्ने मान्छे!
· Posts 1 · Viewed 159
bandedv2023 » pitambar
ढ्याउ गर्दा दसैँको खसी गनाउच
· Posts 24 · Viewed 7435 · Likes 2
sm01234 » Logan
emergency donation needed
· Posts 26 · Viewed 2257 · Likes 5
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 83
NepalNews Sajha
News Summary from Nepal for Thursday, April 25, 2024
· Posts 1 · Viewed 102
forthecloset
10 Most popular sex toys hiding places
· Posts 1 · Viewed 184
sojho_bahun » chicagoan
Is this a progressive step?
· Posts 2 · Viewed 286
crazy_love » crazy_love
मन भित्र को पत्रै पत्र!
· Posts 13 · Viewed 3452 · Likes 6



Your Banner Here
Travel Partners
Travel House Nepal