How to find out duplicate records in a table(Query)
Answer Posted / vishal
try this query
select name,count(*) from X1 (X1 being the table name)
group by name
having count(*)>1
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is Recovery Scenario
What is vdd - version description document?
What can be thought of as being based on the project plan, but with greater amounts of detail?
What is test documentation?
What are the emerging trends in the testing and QA arena?
Describe your ideal working environment.
What is quality assurance (qa)?
What are the ways of functional testing? Can you give me an example of how to perform Functional testing on a Login Page for example.
What is an equivalence partition (also known as an equivalence class)?
What is a user manual?
how to use bugzilla plz tell me details processs
how to download fullversion of JIRA(defect reporting s/w) s/w for free.can any provide web site for full version free download.
Explain inspection?
What is incremental analysis?
repeated testing of an already tested program, after modification, to discover any defects introduced or uncovered as a result of the changes in the software being tested or in another related or unrelated software component: