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
- 8884 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
What is the maximum number of columns in a db2 table?
How to find schema of a table in db2?
How to find primary key of a table in db2?
Can there be more than one cursor open for any program?
How do I add a column to an existing table in db2?
Can one database have multiple instances?
Explain the benefits you can get from mainframe connect?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
On which levels locks can be applied?
What is deadlock in db2?
Define data page.
B37 abend during spufi?
Can you tell me how can you find out the # of rows updated after an update statement?
What is a dbrm in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
