write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / mani
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP)GROUP BY EMPNO;
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How does a sorter cache works?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain the pipeline partition with real time example?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is difference between a gateway node and worker node?
How to call shell scripts from informatica?
How do you set a varible in incremental aggregation
What is primary and backup node?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the meaning of decode in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
What are connected or unconnected transformations?
Differentiate between reusable transformation and mapplet.
Why do we need informatica?