How to find out duplicate records in a table(Query)
Answer Posted / deepika galankar
if table " stud " contains data :
studid name
1 xyz
2 pqr
3 per
1 xyz
then query is
select name ,count(name) from stud
group by name
having count(name)>1;
thank u .
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
have u write any sanity testcases?
Explain fault?
Example: A Bank teller determines a need for a new software that displays customer information on her screen. What would using a Waterfall Methodology look like AND what would an Agile Methodology look like in creating this software product?
Explain structural testing?
What is dependency testing?
Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree
What is a system administrator?
In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), what is the INPUT and OUTPUT of each stage?
What is test tools?
Explain exit criteria?
What is intrusive testing?
Explain how to test documents in a project that span across the software development lifecycle?
hi..I am from Pune and i want to take ISTQB.So pls tell me which book i should refer and sample papers?How much time i need to prepare for it?Those who have material pls help me out and mail me at pankaj_r_autela@yahoo.com , And those who are from Pune and have taken this exam ,i vl like to share your knowledge. Thanks in Advance to all of you.. Pankaj
What is latent defect?
Explain glossary of software qa/testing?