How to find out duplicate records in a table(Query)
Answer Posted / lakshmanlal
hi gud evening all, this is lakshmanlal.k.
suppose my table EMP having one column like ENAME in that i
am having 5 values like lakshman,lakshman,siva,rajesh,kiran
now i am writing query for duplicate records
select ename from EMP(tablename)
group by ename
having count(ename)>1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How will you conduct risk analysis?
IN integration testing tester should knowledge of code or not?
Could reviews or inspections be considered part of testing?
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
What are the layers of iSCSI Protocol?
what is the difference between the normal testing and embedded testing?
What is JBOD?
Explain code walkthrough?
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?
What the difference between latent and masked defects is?
What is fuzz testing and when it is used?
In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), what is the INPUT and OUTPUT of each stage?
What is test case generator?
what is modular framework?
wat r d schedules for testing?