Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10105 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
Delete from emp where rowid not in(select min(rowid) from emp group by eid,ename)
in group by column you need mention all column in table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you set a varible in incremental aggregation
In informatics server which files are created during the session rums?
What is data transformation manager process?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Explain lookup transformation in informatica
Reusable transformation and shortcut differences
What is different between the data warehouse and data mart?
what is the Default Source Option For Update Strategy Transformation?
Which development components of informatica have the highest usage?
Design a mapping to load a target table with the following values from the above source?
What is native users?
What is a snowflake schema?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain transaction control transformation in informatica
How to differentiate between the active and passive transformations?
