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
What is null indicator in cobol db2?
What is a plan and package in db2?
What is bufferpool in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
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 are the contents of dclgen?
What is the syntax for creating a table in the db2 database?
What is universal database?
Why do we use cursor?
Define data page.
How does cobol compile db2 program?
What is dbrm?
Is db2 a mainframe database?
What is blu acceleration in db2?
What is the use of predicate?