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 is system testing?
How the 2 wings and body of the butterfly model of test development is represented?
What is path analysis?
What do enterprises do for QC 11 to prevent minimum data loss ?
how cam www sites be tested
What is the difference between test matrix and traceability matrix?
Why is the decision table testing used?
What is upward compression?
What is path testing?
What is static analysis?
What is a test harness?
Hi All!!Can anyone please suggest some better website to learn Mainframe Testing??Am very much new to Mainframes. Thanks in Advance Nithya
can you tell me the correct process for creating automation frame work for project(key word driven framework)
What is system test?
What is control chart?