Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
select r.player_id,r.firstname,r.lastname,r.address1a, r.totaltwin from #report r inner join ( select lastname,address1a from #report group by lastname,address1a having count(*) > 1 ) dr on r.lastname = dr.lastname and r.address1a = dr.address1a
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.