How to find out duplicate records in a table(Query)

Answer Posted / madhav

select name,count(name) from mastertable group by name
having count(name)>1

instead of NAME use your own fields


Best of luck

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what the mean of cmm and tmm?

820


What is technical review?

783


Which is the easiest and preferred Automation Tool mostly for software Testing now a days? What is the reason for it.

1733


What is the average size of executables that you have created?

1096


Explain how you would allocate a task to team members?

764


how many types of automation frame works are there?

942


What are different SCSI command phases?

1894


How do you verify the test results and how do you proceed when you do not get the expected results?

798


Explain what the difference between latent and masked defects is?

823


What is the difference between debugging and testing?

857


What is the dfd (data flow diagram)?

816


What are verification and validation?

792


How will you conduct risk analysis?

875


What is the difference between top-down and bottom-up testing?

778


What is branch coverage?

775