how to get duplicate records from tables?write qurey for this?
Answer Posted / pandu
To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.
Is This Answer Correct ? | 2 Yes | 26 No |
Post New Answer View All Answers
How to take backup of table in db2?
Explain dclgen.
Which isolation level provides maximum concurrency?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What do you mean by commit and rollback?
What is meant by union and union all?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is dclgen in db2?
Discuss about db2 bind?
What is cloudant database?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is reorg and runstats in db2?
What is ibm db2 used for?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Can there be more than one cursor open for any program?