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
What the basic components of defect report format are?
What is random/monkey testing? When is it used?
What is your daily routine in your office?
I need to learn everything I can about Function, Non-Functional and Regression Testing. What is the best online resource?
What can be thought of as being based on the project plan, but with greater amounts of detail?
What is top-down approach?
What is technical review?
What is the average size of executables that you have created?
What is the common risk that leads to project failure?
Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis
What is the difference between web application and desktop application in the scenario of testing?
What is bottom-up testing?
What is memory leaks and buffer overflows ?
What is difference between Agile and V model? Explain
IN integration testing tester should knowledge of code or not?