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
- 9241 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
How do we specify index to include or not during bind process.
Mention data types used in db2 ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is iseries database?
What is sqlca?
What is reorg and runstats in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is dbrm in db2 database?
What is the role of data manager in the db2 database?
What does reorg do in db2?
How to get the ddl of a table in db2?
How to access db2 tables in mainframe?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Explain package in db2 and its advantages?
Define buffer pool.
