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 the term bug.
What is variable trace?
Explain failure?
What the different types of test coverage techniques are?
How to track the requirement from bugzilla tools? As our project requirement are changing frequestly and all are tracked in bugzilla tool. How to manage all as all project having short term duration. Please reply back ASAP? Thanks in advanced?
What is closed box testing?
Explain what lcsaj is?
Hello Frds, Iam Going to attend Face to face interview on coming Monday in Wipro. Iam going with 3+ years of experience.I'm requesting u all of Frds who attended wipro recently pls post your interview experience, the questions they asked so that it will be help ful to me and other frds who are going to attend wipro.. thanks in advance
What are the two parameters which can be useful to know the quality of test execution?
What are the advantages of SCSI compared to ATA or IDE ?
What are the common mistakes which create issues?
What is vdd - version description document?
Evaluation?
What is test documentation?
What is a database administrator?