Amudhan Kuppan

Amudhan Kuppan

  • NA
  • 378
  • 29.8k

Duplicate records in my table

May 3 2018 8:05 AM
how to find a Duplicate records in my table
anyone please help me
iam tried iam send query please check it this is right or wrong
give me duplicate records from the following tables
Select * from DimMember - firstname,lastname,dob
my query is 
select firstname,lastname,dob from dimmember
group by firstname,lastname,dob 
this is right if wrong please send me query

Answers (8)