Posted by: Lee_St January 10, 2019
Login in to Rate this Post:
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
Select FirstName, LastName, count(*) as Count
from Name
Group by FirstName, LastName
Having Count(*) = 1