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
- 76951 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / amit bhatnagar
Swati is cool. buth her queries are correct. you can either
take rowid >with subquery fetching minimum (rowid) else
Rowid < with subquery fething maximum (row id)
DELETE FROM <table_name> T1
WHERE T1.ROWID > (SELECT MIN(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
----------------------------
DELETE FROM <table_name> T1
WHERE T1.ROWID < (SELECT MAX(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
Good job Swati.. :)
| Is This Answer Correct ? | 15 Yes | 6 No |
Post New Answer View All Answers
Tell me how to debug the report?
What is a value set? List its various types.
What is a flexfield? List out its types.
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
can we get profile values in report without using user exists is it possible how?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
what is the difference between request group and request security in oracle apps?
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 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
Which oracle apps version you are very confident in?
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
tell me the scenarios of the independent in reports
Can you explain the difference between architecture followed in 10g & 11g?
Explain oracle apps architecture.
