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 db2 look?

1079

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

1178

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1111

What is schema in db2?

1084

What is ibm db2 database?

1069

Which command is used to connect to a database in DB2 ? Give the Syntax.

1153

Can we insert update delete in view?

1030

What is the function of logging in the db2 database?

1174

Define data page.

1133

If I have a view which is a join of two or more tables, can this view be updateable?

1187

Mention the downsides of page level lock.

1220

What are host variables in db2?

1125

How do I connect my db2 database to ibm?

1087

What is the use of with ur in db2?

1110

What os does db2 run on?

1049