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


how to eliminate duplictes in column except group and
section?

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.
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

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 smalipaki@yahoo.com

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  


Categories
  • 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)