write a query for how to eliminate the duplicate rows
without using distinct?
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 |
Post New Answer View All Answers
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How are the sources and targets definitions imported in informatica designer?
What is target load order?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is status code in informatica?
Explain the mapping variable usage example in informatica
what is the size of u r source(like file or table)?
What is meant by query override?
What is informatica?
can we override a native sql query within informatica? How do we do it?
What is session task and command task?
Briefly define reusable transformation?
Explain the informatica workflow?
what is degenerated dimension?