try this query select name,count(*) from X1 (X1 being the table name) g

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

Question Posted / vishal

Answer Posted / vishal

try this query

select name,count(*) from X1 (X1 being the table name)
group by name
having count(*)>1

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Which is the easiest and preferred Automation Tool mostly for software Testing now a days? What is the reason for it.

1718

how to use bugzilla plz tell me details processs

1769

What is race condition?

846

Explain performance testing?

813

Can anyone provide the definitions for the following abbreviations? Thanx to anyone who could CIT CAP

1860

Explain cyclomatic complexity?

869

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

1764

Which activity in the fundamental test process includes evaluation of the testability of the requirements and system?

973

What is failure?

826

Explain black-box testing?

766

What is CDB?

1731

What is negative and positive testing?

821

What is version description document (vdd)?

835

Explain testability?

918

What is the common risk that leads to project failure?

829