Select column_name1,column_name2 from table_T group by column

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

Question Posted / anshuman

Answer Posted / anshuman

Select column_name1,column_name2
from table_T
group by column_name1 having count(*)>1

it will give all the duplicates value of column_name1

Is This Answer Correct ?

28 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is deadlock in db2?

1017

What is declare cursor?

1043

what is diffrence b/w file-aid tool and file-aid utility???

4809

B37 abend during spufi?

1405

What are the bind parameters ibm db2?

989

Which command is used to remove all rows from a table?

1038

What is database alias db2?

1066

Is db2 a mainframe database?

942

What are the various isolation levels possible?

1048

How is deadlock resolved?

1081

Mention some fields that are a part of sqlca.

970

What is the function of logging in the db2 database?

1069

What is temporal table in db2?

988

What is bufferpool in db2?

984

Explain about rct in db2?

1043