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

What is commit in db2?

1055

What is view db2?

1076

When reorg is used?

1127

What is the cobol picture clause of the db2 data types date, time, timestamp?

1067

How to connect to db2 database from windows command line?

1065

How can we retrieve the total number of records in RPG & CLLE?

655

Can we update view in db2?

1002

How do you stop a db2 database in linux?

1013

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1106

What is coalesce in db2?

1134

Is db2 a mainframe?

1043

What is the difference between oracle and db2?

1108

Mention some fields that are a part of sqlca.

1033

What is the information associated with sysibm.syslinks table?

1123

What is the role of schema in the db2 database?

1274