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
Explain debugging?
Explain Peer Review in Software Testing?
Which one you prefer, working with independent testing project or working along with development team?
how i find swing lenth of probe ?
What is test incident report?
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 monkey testing?
What are the Difficulties you found while testing your module ? plese give the possible difficulties.
Explain 3 high priority test cases for the performance of MSN search engine.
What is random/monkey testing?
What is a database administrator?
What is clear box testing?
Explain what is testing type and what are the commonly used testing type?
What is top-down approach?
What are the goals in your career as Test Engineer if u join the new compnay