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 are the different types of QA Testing approaches and the process of each?
Explain storage testing?
Explain what is testing type and what are the commonly used testing type?
Explain validation?
Can any of u help me... How to use Security below listed testing tools 1. XSS Probe 2. SQL Power Injector 3. CAL9000 I have to do security testing using these tools.But I do not have any knowlwdge on this. I am trying to work using Help doc, but use, not able to follow Pls do needful
Explain cause-effect graphing?
What is heuristics testing?
What is the negative and positive testing?
What is partition testing?
Hi can anyone guide me regarding how the interview procedures will be in exterro Inc, Coimbatore
Explain code inspection?
please anyone can help me in giving dumps in ISTQB for foundation level
What is a 'walkthrough' in Software Testing?
26). how will know do written test cases are sufficient to validate application of functionality? 27). how will you prepare test data to validate input object? 28). explain defect status? 29). how will know whether the developer accepted you defects or not? 30). explain acceptance test? 31). explain when we stop testing? 32). explain scope of your project? 33). in which module you conducted testing? 34). explain defects which you found in that module? 35). if defect is not reproducible then what information you will provide to developer 36). if developer is not accepted your defect then what you will do?
Explain static analysis?