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
- 9097 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 to connect to db2 database from windows command line?
What is bind in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
List out the data types available.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is alias in db2?
What is a bind card?
How does db2 sample database connect?
What is a dbrm in db2?
What is reorg?
How to find the number of rows in db2 tables?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I delete a table in db2?
Who uses db2?
What is the use of with ur in db2?
