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

What is api (application programming interface)?

830


What are the different methodologies in agile development model?

871


Usually how many members work in a project & how members are now working in a project. If there r difference between the above two questions why it is so?

2026


When is used decision table testing?

809


What is the difference between the white box, black box, and gray box testing?

799


What is what are the parameters of performance testing?

823


Explain black-box testing?

773


Explain good design?

856


What is test result analyzer?

997


how cam www sites be tested

1698


Innovative suggestions, solutions, if any, brought out by you for the better performance of the Quality and Testing department/ company during the review period: Anybody can answer to this question..Thanks in advance..venkat

2539


What are benefits of iSCSI SAN over FCOE SAN?

3354


EXPLAIN HISTORY OF SOFTWARE ENGINERRING? ISO & CMM certification and its use in context to software testing

1770


What is the function of the software testing tool 'phantom'?

1178


Explain defect?

775