select name,count(name) from mastertable group by name having count(name)&

How to find out duplicate records in a table(Query)

Question Posted / madhav

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

Please Help Members By Posting Answers For Below Questions

What is test environment?

834

how cam www sites be tested

1690

What is loop testing?

838

How to write an implementation plan for our QA system with small budget, from scratch.

1887

What is end-to-end testing?

802

How would you estimate the amount of re-testing likely to be required?

959

What do you mean by trend analysis?

871

Explain what test deliverables is?

766

Is it true that we can do system testing at any stage?

763

What is random/monkey testing? When is it used?

817

What is CCB and MTBF, why should we use this.

1998

What is outputs?

752

Explain test driver?

766

What is 'fish pond analysis' with respect to software testing?

762

What is fault masking explain with example?

835