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
5772 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

What is the use of reorg in db2?

1027

Explain in detail about buffer manager and its functionalities?

996

What is dclgen (declaration generator)?

1012

What does db2 mean?

957

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1182

What is multi row fetch in db2?

988

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

1068

Explain the function done by data manager?

1219

Explain package in db2 and its advantages?

1138

What is the difference between cursor and select statement?

1056

What is db2?

1126

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1093

What is meant by dclgen?

1061

How to check last update on table in db2?

1004

How to compare data between two tables in db2?

1033