Interested to Buy Any Domain ? << Click Here >> for more details...
how to eliminate duplictes in column except group and
section?
- 2 Answers
- 6981 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 are the various methods of performing a calculation in a report ?
How do you reference a Parameter?
What do you understand by lov?
What do you understand by oracle forms?
What does TKPROF stand for?
What are all the system Parameters available in ORACLE Reports
what is bit map and character mode
What is lexical reference?How can it be created?
what is Oracle10g? Please refer some sites...
What is the built-in used to get and set lov properties during run-time?
what are difference between post database commit and post-form commit?
What is a timer?
Oracle General 
