Amudhan Kuppan

Amudhan Kuppan

  • NA
  • 378
  • 29.5k

Duplicate Records in my table

May 7 2018 11:59 PM
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

Attachment: Duplicate_record.rar

Answers (10)