Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 9088 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
Explain the contents that are a part of dclgen.
What is clone table?
Why cursor is used in db2?
What is the default page size of buffer pools?
What are db2 tables?
What is commit in db2?
What is universal database?
What is the role of data manager in the db2 database?
Why select is not preferred in embedded sql programs?
B37 abend during spufi?
What are the full forms of spufi and dclgen and why are they used?
How many databases can be created inside an instance in db2 ?
What do you mean by rollback?
Is the primary key a clustered index?
What is phantom read in db2?
