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 runstats utility in db2?

1018

What is db2 bind process?

1236

What is db2 catalog database?

1040

What is the advantage in De-normalizing tables in DB2?

1169

What is the use of commit in db2?

1073

How to fetch the last row from the table in SQL (db2)?

1651

What is the maximum size of varchar data type in db2?

1131

What is a db2 table?

1009

What is the use of runstats in db2?

1104

Can we delete records from view?

966

What is runstats and reorg in db2?

1297

What are packages in db2?

1019

What is the difference between spufi and qmf?

1126

Why do we use cursor?

1097

What is the result of open cursor statement?

1081