DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM EMP GROUP BY EM

write a query for how to eliminate the duplicate rows
without using distinct?

Question Posted / madhu

Answer Posted / madhu

DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP GROUP BY EMPNO);

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

Can anyone tell me the new features in Informatica 9 Version?

2127

waht type of interface is used for testing the data in informatica

2257

expain about the tune parameters?

2414

complex mapping ur project u r invlve can u explain and give real time example give me ?

2298

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518

Differentiate between router and filter transformation?

1012

Which transformation should we use to normalise the COBOL and relational sources?

1209

Clarify the utilization of aggregator cache record?

1001

Can we create two repositories on same database instance in oracle?

1093

What is the need of an ETL tool?

1094

What are the measure objects?

1202

What is target designer and target load order?

1104

Describe an informatica powercenter?

1127

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032