SELECT <Column Name1> FROM Table GROUP BY <Column Name1> HAVIN

how will i display the duplicate record's from a table...
i don't want to eliminate ...i want to display the duplicate
record...for example in my table i have 10 record's like
record no(1,2,3,4,2,9,6,1) in this ...so i want to receive
duplicates...

Question Posted / raja_kb

1 Answers
5937 Views
UST, I also Faced
E-Mail Answers

Answer Posted / raja_kb

SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create db2 table in mainframe?

1217

What is phantom read in db2?

1224

i want to maintain uniqueness on pdf without make lf??????????

2204

What is the maximum number of columns in a db2 table?

1343

Can we update view in db2?

1053

Explain about rct in db2?

1163

Define data page.

1128

What are foreign keys in db2?

1170

How to find schema of a table in db2?

1066

How to execute stored procedures?

1175

Explain in detail about buffer manager and its functionalities?

1142

What is consistency token in db2?

1194

What is the syntax for creating a table in the db2 database?

1148

What do you mean by commit and rollback?

1087

How do I add a column to an existing table in db2?

1082