Interested to Buy Any Domain ? << Click Here >> for more details...
how to eliminate duplictes in column except group and
section?
- 2 Answers
- 7089 Views
- iFlex, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep
the above answer will work ifonly one dplicate row is there,
if there are more than one duplication.
then
delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name having count(*)>1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / jagan
delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)
| Is This Answer Correct ? | 5 Yes | 3 No |
What SYNCHRONIZE procedure does ?
how to call forms in parametar forms
how to send file attachment from oracle forms
What is an Invoice ? How many types of invoices are there in AP and AR ?
What is the difference between OLE Server & Ole Container?
Name of the functions used to get/set canvas properties?
what is bit map and character mode
what is an object groups?
At what point of report execution is the before Report trigger fired?
what exactly u write in when_new_form_instance
What is a Package Procedure ?
What is the frame & repeating frame?
Oracle General 
