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

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 ?

2122

How many databases are there?

989

How many types of page locks can be held in db2?

991

How do I copy a table in db2?

948

What does db2 plan contain?

958

What is the information associated with sysibm.syslinks table?

1055

What do you mean by rollback?

932

What is meant by explain?

1058

What is reorg?

1062

What is explain plan in db2?

940

Before you give the explain statement, what are the prerogatives?

968

What is a db2 schema?

1172

What is an instance database?

1002

How to view db2 table structure?

959

What is the physical storage length of timestamp data type?

1022