Duplicate records in the PerioMeasure table.
Posted: Mon Jan 08, 2024 4:18 am
Hi,
We are seeing lot of duplicate records for sequence type 4,5,6 in PerioMeasure table, below is the query we are running to check the data.
Can you please confirm why we are seeing the duplicate records for above sequence type?
Thanks.
We are seeing lot of duplicate records for sequence type 4,5,6 in PerioMeasure table, below is the query we are running to check the data.
Code: Select all
select SequenceType , IntTooth , PerioExamNum from perioMeasure group by SequenceType , IntTooth , PerioExamNum having count(*) > 1;Thanks.