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 8155 · 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 हेलो शुक्रबार, गुड्बाइ लुइटेल
Visitor is reading PRISMS--by SITARA
Visitor from US is reading top 3 schools/colleges in Nepal
Visitor from US is reading help me....
Visitor from US is reading nepali instrumental melody
Visitor is reading you tube
Visitor from CA is reading Conspiracy and deception of Bahuns:
Visitor is reading Mad about Snowden? Did you hear about Rebekah Jones?
You might like these other discussions...
xkavrepalanchok » Tps8249
Obama Illinois federal judge --- rules illegal migrants can carry guns legally !
· Posts 6 · Viewed 513
kale dai » logan
lost $3500 on penny stocks !!!
· Posts 10 · Viewed 1031 · Likes 1
independent
When Woody Harrelson joked about the media
· Posts 1 · Viewed 89
furke » haal haal pandit
Trasiting through Istanbul, Turkey
· Posts 2 · Viewed 231
Sajha Classifieds
Classifieds Summary: Jobs in MA, Room/Apt in MA,VA
· Posts 1 · Viewed 75
NepalNews Sajha
News Summary from Nepal for Monday, April 29, 2024
· Posts 1 · Viewed 65
xkavrepalanchok » Tesla guy
They are openly permitting undocumented immigrants to participate in federal elections in Arizona now.
· Posts 3 · Viewed 785 · Likes 2
xkavrepalanchok » Tesla guy
They deserve priority due to their language barrier. But whose fault is that? Entering the country illegally knowing English is essential.
· Posts 2 · Viewed 246
xkavrepalanchok
If the democrats didn't have double standards, they'd have no standards at all.
· Posts 1 · Viewed 155
Sajha Classifieds
Classifieds Summary: Room/Apt in CO,VA
· Posts 1 · Viewed 129



Your Banner Here
Travel Partners
Travel House Nepal