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
- 77064 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / veera
delete from tablename where rowid not in(select min(rowid)
from table name group by duplicate record col)
| Is This Answer Correct ? | 37 Yes | 21 No |
Post New Answer View All Answers
How to move the one file from one instance to another instance? And your scripts also?
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 soa?
what are the balancing segments in AR?
Which oracle apps version you are very confident in?
How to create a purchase order without a requisition?
What are the benefits of using soa architecture?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What are do's and dont's of Interface?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What are file in oracle.
What does appl_top directory contain?
What do you understand by concurrent programs?
how to print multi lay outs,muti currency,muti language in xml publisher
