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...
- 1 Answers
- 5489 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
What is lock escalation in db2?
What is universal database?
What is temporal table in db2?
Can you use max on a char column?
What is node in db2?
Which is faster delete or truncate?
What is db2 look?
What does db2 plan contain?
Explain about dbrm.
What are host variables in db2?
Explain the contention situations caused by locks?
What is copy pending and check pending in db2?
What is the use of dclgen in db2?
What is dclgen in db2?
What is a cursor in programming?
