Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71218 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / amit shrivastava
Delete from table where rowid not in (select max(rowid)from
table group by column_name);
Delete from table T1 where rowid < (select min(rowid) from
table T2 where T1.emp_name=T2.emp_name);
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Can u give the Documentation of Custom.pll in oracle apps
Tell me how to debug the report?
Can you define an erp system?
Explain what are the tables of auto invoice?
In oracle application how do you debug or trace errors?
In hierarchical structure of a database? we have write query from where we should start?
testing tools?
What are the different components you should consider while defining a responsibility in oracle apps?
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by a set of books?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
how do you describe O2C along with tables
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How to move the one file from one instance to another instance? And your scripts also?
How many schemas we have? how many you have used?
