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

Can we override a native sql query within informatica?

1030

Write the unconnected lookup syntax?

1077

What is the benefit of session partitioning?

1109

Is it possible to define a single node as a Gateway node as well as worker node?

1115

How you know when to use a static cache and dynamic cache in lookup transformation?

1847

What are the new features of informatica 9.x at the developer level?

1031

How would you copy the content of one repository to another repository?

1010

Define mapping and session?

1024

Explain the etl program with few examples.

1039

What is the maplet?

1103

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1895

How to load data in informatica ?

996

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7036

define galaxy repository in informatica

2216

what are the Methods For Creating Reusable Transformations?

1161