delete from emp where ecode IN ( select ecode from emp group by ecode havin

How will you delete duplicate records from a table?

Question Posted / venkat

Answer Posted / venkat

delete from emp where ecode IN ( select ecode from emp group by ecode having count(*) >1 )

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain db2.

991

Define predicate?

1065

Why db2 is called db2?

970

What is the use of db2 optimizer?

1036

How to fetch the last row from the table in SQL (db2)?

1588

What is performance tuning db2?

1007

B37 abend during spufi?

1405

What is dbrm?

1046

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1135

What is an instance in db2?

982

What are the contents of dclgen?

1053

List out the data types available.

1081

What is coalesce in db2?

1055

Mention the downsides of page level lock.

1112

Mention the various locks that are available in db2.

973