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
- 78494 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
what are the balancing segments in AR?
What do you understand by concurrent programs?
How to create a purchase order without a requisition?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
how do you describe O2C along with tables
Do you know what is applysys in oracle application database schema, what is apps?
What are the benefits of using soa architecture?
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 print multi lay outs,muti currency,muti language in xml publisher
how can i print random rows in plsql table
What are file in oracle.
What is sca and how is it useful?
What is a flexfield? List out its types.
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
pls send me out bound code of supplers,site,bankiformation code pls as soon as
