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
What are the maximum no. of devices supported in SCS-1,2 and 3?
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?
Mention what are the categories of defects?
What is functional system testing?
How do you obtain the expected results for testing a search operation?
Explain metric?
The Following Characterstics posses some XYZ company. * Uses formal standards and policies * Conducts software inspections * Has advanced configuration management and change control * Uses CASE tools * Has a software engineering process group * Gathers metrics on process and quality * Requires that developers have formal software engineering training * Practices continued process improvement Based on aboue , Tell me which CMM Level is the company..? 1. Level 1 - Initial 2. Level 2 - Repeatable 3. Level 3 - Defined 4. Level 4 - Managed 5. Level 5 - Optimizing
What is quality circle?
Explain basis path testing?
What is difference between known regression testing and unknown regression testing?
What is the main goal of defect prevention meeting?
What is top-down strategy?
Mention what the basic components of defect report format are?
you are a SQA lead on a project that uses an agile development environment, The lead developer has been instructed to write and initially-failing automated test case, then produce minimum amount of code to pass the test and finally refactor the new code to acceptable standards. based on above, Which type of SQA-focused SDLA is being used?
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