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

How does a rank transform differ from aggregator transform functions max and min?

1165

How to load data in informatica ?

971

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

2252

What are the components of the workflow manager?

1095

What is xml source qualifier transformation in informatica?

1186

What are the steps involved in the migration from older version to newer version of Informatica Server?

2065

What are the static cache and dynamic cache in informatica?

1152

What is meant by target load plan?

929

In informatica workflow manager, how many repositories can be created?

1295

my source is junk data how will u remove that junk data by using unix please any one replay me

3662

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1285

Please let me know how to make Data masking in informatica..

1679

What is rank transformation?

947

What are the tasks that can be performed using sq?

1042

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1953