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
Do you know what the mean of cmm and tmm?
What is technical review?
Which is the easiest and preferred Automation Tool mostly for software Testing now a days? What is the reason for it.
What is the average size of executables that you have created?
Explain how you would allocate a task to team members?
how many types of automation frame works are there?
What are different SCSI command phases?
How do you verify the test results and how do you proceed when you do not get the expected results?
Explain what the difference between latent and masked defects is?
What is the difference between debugging and testing?
What is the dfd (data flow diagram)?
What are verification and validation?
How will you conduct risk analysis?
What is the difference between top-down and bottom-up testing?
What is branch coverage?