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
- 76974 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / srinivas
delete from emp where rowid not in(select max(rowid) from
emp group by sal);
and
delete from(select distinct sal from emp) where rowid>=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
What is a flexfield? List out its types.
How many schemas we have? how many you have used?
List the types of flexfield?
tell me the scenarios of the independent in reports
tell my any difficult situtation you solved in your experience in your company?
where to define interorganization transaction charges and what are the different options?
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?
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
What are do's and dont's of Interface?
what is the differences between internal requisition and internal sales order?
What are the different components you should consider while defining a responsibility in oracle apps?
what is global tempory table?
What do you understand by concurrent programs?
Which oracle apps version you are very confident in?
