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
- 5322 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
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Define declaration generator (dclgen).
What is buffer pool?
What is a page in db2?
What are the prerogatives?
How does cobol compile db2 program?
Explain dclgen.
What are the full forms of spufi and dclgen and why are they used?
What are the two types of logging in the db2 database? Explain them.
What is a Foreign Key?
Is db2 a programming language?
What are packages in db2?
What is data manager?
Explain about mirror activator disk mirroring?
How to execute stored procedure in db2 command editor?
