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 do I import a csv file into db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain various types of locks in db2?
can we view the access paths created by dbrm ? how ? thx
What is the picture clause of null indicator variable?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is with ur in db2?
What are iseries servers?
List down the types of triggers in the db2 database?
What is access path in db2?
What do you mean by rollback?
What do you mean by storage group (stogroup)?
Is db2 relational database?
What type of database is db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?