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
- 77825 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / swati
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>)
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
What are the different components of soa suite?
tell me the scenarios of the independent in reports
List the various types of value set.
What are do's and dont's of Interface?
What is oracle soa suite and what are its different components?
Can u give the Documentation of Custom.pll in oracle apps
Are you familiar with internet architecture of oracle apps 11i?
How to create a purchase order without a requisition?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What do you understand by soa?
q)what are the validations in sql*loader
how can develope the po variance and po summary report? with tables mandatory columns and query please?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What is sca and how is it useful?
Which oracle apps version you are very confident in?
