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...
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
what is db2 restart?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is cursor with hold option in db2?
Describe major components of db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How does a cursor work?
How do I create a view in db2?
What is sqlca?
What is meant by dclgen?
What are the rules for db2 programming?
How to rename a table in DB2 ?
Explain various types of locks in db2?
How to access db2 tables in mainframe?
What is performance tuning db2?