How to find out duplicate records in a table(Query)
Answer Posted / madhav
select name,count(name) from mastertable group by name
having count(name)>1
instead of NAME use your own fields
Best of luck
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Explain debugging?
I am having 1.5 years of exp. in Manual testing.What I have to do now? Should I do ISTQB Certification or Perl/Shell Scripting Languages? OR Anything else.Please Guide me properly.
What is boundary value testing?
What's Stress Testing?
How many test cases will be there for testing the numbers of range -10.0 to 10.0? How it is classifying?
Explain branch testing?
How would you test the login feature of a web application?
Explain storage testing?
What are the different types of QA Testing approaches and the process of each?
What is recovery/error testing?
How do you obtain the expected results for testing a search operation?
Mention what the difference between pilot and beta testing is?
1). explain need of software testing? 2). explain difference between developer testing & test engineers testing? 3). explain difference between verification & validation 4). which process your organization follows to develop an application? 5). explain v-model? & what is the meeting point in v-model?
What are the categories of defects?
What are the emerging trends in the testing and QA arena?