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


Please Help Members By Posting Answers For Below Questions

have u write any sanity testcases?

1937


Explain fault?

834


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?

889


Explain structural testing?

866


What is dependency testing?

866


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

1733


What is a system administrator?

854


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?

657


What is test tools?

896


Explain exit criteria?

826


What is intrusive testing?

912


Explain how to test documents in a project that span across the software development lifecycle?

951


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

1816


What is latent defect?

802


Explain glossary of software qa/testing?

874