Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 8086 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 difference between cursor stability and repeatable read isolation levels?
Define declaration generator (dclgen).
List down the types of triggers in the db2 database?
What is a system catalog table in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the clustering index in the db2 database?
Why select is not preferred in embedded sql programs?
How to fetch the last row from the table in SQL (db2)?
What does db2 stand for?
What is the usage of open cursor command?
What is the purpose of rollback and commit?
How do you select a row using indexes in db2?
Is ibm db2 free?
What are the 2 sqlcodes that are returned?
What is check constraint in db2?
