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
- 9244 Views
- I also Faced
- E-Mail Answers
Answer Posted / gouri
select column_1 from tablename groupby column1 having coun(*)>1
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
How is the value function used?
How do I add a column to an existing table in db2?
How to compare data between two tables in db2?
What is load replace in db2?
How to connect to db2 database from windows command line?
what is db2 restart?
How many databases can be created inside an instance in db2 ?
What is the advantage in De-normalizing tables in DB2?
Which component is used to execute the sql statements?
What is the difference between db2 and oracle?
Which component is responsible for processing sql statements and selecting access paths?
What is buffer pool and list some of them?
What is a db2 package?
What is database alias db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
