Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / koti
Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
How is choreography different from orchestration?
tell me the scenarios of the independent in reports
What is instead of trigger in where we will use?
In hierarchical structure of a database? we have write query from where we should start?
What is oracle soa suite?
how to print multi lay outs,muti currency,muti language in xml publisher
What are do's and dont's of Interface?
Do you know what is applysys in oracle application database schema, what is apps?
what are the prerequisites for costing transactions?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Can you explain the difference between architecture followed in 10g & 11g?
What is a flexfield? List out its types.
Can you differentiate between mediator and osb?
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?
What do you understand by a set of books?