Posted by: phone January 11, 2019
How to find unique values without using distinct function in SQL Server ?
Login in to Rate this Post:     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.
Read Full Discussion Thread for this article