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


Please Help Members By Posting Answers For Below Questions

Say your Product passed through testing and UAT. Now it went to production at client location and they found one defect in it. How they need to procced now? Will they contact you? Will they contact dev team?

795


How will you log a Defect when you are in the process of executing a test case?

1929


What is branch coverage?

777


What is fault tree analysis?

925


What is difference between validation and verification?

789


Test engineer?

794


What is fuzz testing and when it is used?

807


what is system testing?

1806


can you tell me the correct process for creating automation frame work for project(key word driven framework)

1795


what is the meaning of Field Level Validation & Form Level Validation??

2334


Hi do any one has dumps for ISTQB or ISEB exams for august or september exam 2013. Pleae mail qazwsx2631981@yahoo.co.in

2078


Explain testing?

811


Mention the difference between data driven testing and retesting?

835


What is bottom-up strategy?

836


Explain testability?

938