To get the duplicate records in a table use the query Select distinct(dept

how to get duplicate records from tables?write qurey for this?

Question Posted / pandu

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

Please Help Members By Posting Answers For Below Questions

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

789

How to find the number of rows in db2 tables?

792

What is a bind card?

869

What is check constraint in db2?

804

How do I add a column in db2?

773

Who uses db2?

754

How would the varchar column remarks defined?

832

What is drop table?

763

What is image copy in db2?

747

What is schema in db2?

768

Explain about rct in db2?

864

What are iseries servers?

759

what is db2 restart?

1894

What is the physical storage length of timestamp data type?

851

How do I delete a table in db2?

818