select column_name,count(*) from table_name group by column

how to get duplicate records from tables?write qurey for this?

Question Posted / mahesh babu

Answer Posted / mahesh babu

select column_name,count(*) from table_name group by
column_name having count>1.

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is package in cobol db2?

698

How can we retrieve the total number of records in RPG & CLLE?

190

How to find the number of rows in a db2 table?

644

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1708

Explain package in db2 and its advantages?

589

What is the physical storage length of date data type?

722

What are bind parameters in db2?

609

What is explain in db2?

580

What is check constraint. Explain with example.

642

What does sqlcabc has?

625

Define data page.

626

How to retrieve rows from a db2 table in embedded sql?

714

Can you use max on a char column?

634

Explain how can you do the explain of a dynamic sql statement?

649

What are catalog tables in db2?

601