Given such a table, what is the correct SQL syntax (SQL Server 2000) that would return the first three row (i.e. disregards first name, and returns rows with duplicate last name AND email AND telephone)?
select *
from employee a
where exists (select LastName, Email, Telephone
from employee b
where a.LastName = b.LastName and
a.Email = b.Email and
a.Telephone = b.Telephone
group by LastName, Email, Telephone
having count(*) > 1)
Finding duplicate rows by matching multiple fields
Posted - 04/20/2011 : 19:18:41
