Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 78506 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / arjun
delete from employ where rowid not in(select min(rowid) from
employ group by id,ename,age);
Arjun
| Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
tell me the scenarios of the independent in reports
Can you differentiate between mediator and osb?
How to move the one file from one instance to another instance? And your scripts also?
Explain oracle apps architecture.
What is the concept of soa governance?
what is the difference between request group and request security in oracle apps?
What are the Standard Reports and Forms in HRMS?
where to define interorganization transaction charges and what are the different options?
is it possible to run the interface without using oracle apps?
In hierarchical structure of a database? we have write query from where we should start?
List the types of flexfield?
What are the different components you should consider while defining a responsibility in oracle apps?
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?
q)what are the validations in sql*loader
