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
- 77940 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / koti
delete from emk tl
where tl.rowid >
( select min(tl2.rowID) from emk tl2
where tl.empno = tl2.empno
and tl.ename = tl2.ename)
Madhuapps,is alsow right...
| Is This Answer Correct ? | 16 Yes | 10 No |
Post New Answer View All Answers
Do you know where we can check the status of po?
tell my any difficult situtation you solved in your experience in your company?
What is instead of trigger in where we will use?
What is sca and how is it useful?
What are the different components you should consider while defining a responsibility in oracle apps?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to debug the report?
How can a process be deployed in soa?
what is global tempory table?
How can we import the data into a database using sql * loader?
What are the different components of soa suite?
what is the difference between request group and request security in oracle apps?
List the various types of value set.
How to create a purchase order without a requisition?
What do you understand by a set of books?
