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
- 76954 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 is a value set? List its various types.
what is pay run id ?
What do you understand by soa and what are the benefits of using this architecture?
What do you understand by soa?
How to move the one file from one instance to another instance? And your scripts also?
Do you know what are user profiles in apps. Any examples you can give?
What is count(*) from po_vendors(any table)?
how can i print random rows in plsql table
How is choreography different from orchestration?
Are you familiar with internet architecture of oracle apps 11i?
In oracle application how do you debug or trace errors?
Can you explain the difference between architecture followed in 10g & 11g?
can we get profile values in report without using user exists is it possible how?
how to print multi lay outs,muti currency,muti language in xml publisher
What are the benefits of using soa architecture?
