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
What is api (application programming interface)?
What are the different methodologies in agile development model?
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?
When is used decision table testing?
What is the difference between the white box, black box, and gray box testing?
What is what are the parameters of performance testing?
Explain black-box testing?
Explain good design?
What is test result analyzer?
how cam www sites be tested
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
What are benefits of iSCSI SAN over FCOE SAN?
EXPLAIN HISTORY OF SOFTWARE ENGINERRING? ISO & CMM certification and its use in context to software testing
What is the function of the software testing tool 'phantom'?
Explain defect?