Duplicate Records in my table

Question

hi

 

anyone please help me

how to find a duplicate records in my table

iam tried it will give duplicate record also but my seniors are told this is wrong

wait i will send question and answer any change please update me

give me duplicate records from the following tables..

 

use Dev_SF_PhysicianPartner

go

select from dimmember -- firstname,lastname,dob

select from DimPCP --firstname,lastname or npi

select * from DimOfficeLocation -- officename,tin

 

this is a question

and iam send a one file that is answer please check it any change please update m