Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 11870 Views
- iGate, I also Faced
- E-Mail Answers
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
Explain the pipeline partition with real time example?
What is incremental aggregation?
How we can create indexes after completing the loan process?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How do you change a non-reusable transformation to reusable transformation?
Write the prerequisite tasks to achieve the session partition?
In warehouses how many schemas are there?
What is a stored procedure transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
Define the various join types of joiner transformation?
Target increases every day even though no new record was inserted
How do you load only null records into target? Explain through mapping flow.
What is rank transformation?
What do mean by local and global repository?
What the difference is between a database, a data warehouse and a data mart?
