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 an instance database?

1035

Which are the db2 tools to protect integrity of the database?

1110

What is the function of logging in the db2 database?

1102

Why cursor is used in db2?

1022

What happens in bind step in a db2 program?

958

Which components manage deadlocks in db2?

1052

What is db2 bind process?

1223

Mention the different locking levels that are available in db2.

1116

What are types of indexes?

1042

Are view updateable?

1021

What is dbrm? When it will be created?

1010

What is dbrm? What it contains? When it will be created?

1032

What is package in cobol db2?

1107

How to check sequence on a table in db2?

1046

How do you stop a db2 database in linux?

993