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

Mention the downsides of page level lock.

1165

What are db2 objects?

1053

What is the use of commit in db2?

1084

What do you mean by commit and rollback?

1049

Which component is responsible for processing sql statements and selecting access paths?

1135

What are the various isolation levels possible?

1124

Can we delete records from view?

972

How do you pull up a query which was previously saved in qmf?

1156

Differentiate between cs and rr isolation levels? Where do you specify them?

1074

What is difference between alias and synonym in db2?

1149

How to access db2 tables in mainframe?

1059

What is release/acquire in bind?

1112

What is load utility in db2?

1184

Explain the function done by data manager?

1285

When reorg is used?

1137