Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 8084 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanj
say col1 is having duplicates in table tabA.Then,
select col1 from tabA
group by col1 having (count(col1) > 1)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
List out the buffer pools in db2
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What are the two types of logging in the db2 database? Explain them.
can we view the access paths created by dbrm ? how ? thx
How to check sequence on a table in db2?
How can record locking be achieved in those DB2 versions which do not support it?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is performance tuning db2?
What is sqlca’s maximum length?
What is clone table?
Explain the contention situations caused by locks?
Differentiate between cs and rr isolation levels? Where do you specify them?
How to find the number of rows in a db2 table?
What is the usage of open cursor command?
