Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

how to eliminate duplictes in column except group and

Answers were Sorted based on User's Feedback

how to eliminate duplictes in column except group and section?..

Answer / sandeep

the above answer will work ifonly one dplicate row is there,
if there are more than one duplication.

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

how to eliminate duplictes in column except group and section?..

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

Post New Answer

More Oracle Forms Reports Interview Questions

Where do u define the select statement of the parameter? is it followed by the & variable ?

2 Answers   Zensar,

what is a package n what r the packages availbla in report

0 Answers   Convergys,

What is the difference between BPA AND Contract What are documents and test cases u followed

0 Answers   Zensar,

Can you attach an alert to a field?

2 Answers  

what is difference between group above and group left report

0 Answers   Oracle,

What is an SQL FORMS ?

0 Answers   Verizon,

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI

5 Answers  

How i get the client m/c IP address.

2 Answers  

What is a list item?

1 Answers  

When a form is invoked with call_form, Does oracle forms issues a save point?

1 Answers  

What are the different default triggers created when Master Deletes Property is set to isolated?

1 Answers  

What are the built_ins used the display the LOV?

1 Answers  

  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)