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

What is informatica? Why do we need it?

1108

Define mapplet?

1018

Why do you use Mapping Parameter and mapping variable?

1773

What are the differences between a connected lookup and unconnected lookup?

1071

How we can use union transformation?

1064

What is an expression transformation?

1024

Briefly define reusable transformation?

1136

Explain load alternative records / rows into multiple targets - informatica

1160

What are the main issues while working with flat files as source and as targets ?

1168

What can we do to improve the performance of informatica aggregator transformation?

1098

If informatica has its scheduler why using third party scheduler?

1271

Why sorter is an active transformation?

1201

How identifying bottlenecks in various components of informatica and resolving them?

1138

How to go to the older version for a mapping?

1103

While migrating the data from one environment to another environment how would you manage the connections?

1091