how to eliminate duplictes in column except group and
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.
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|
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
What is a record Group?
Explain about stacked canvas views?
What are the menu items that oracle forms 4.0 supports?
What is term? What is use of term?
why the Ctl file u put only in bin folder why not in other folder
What are the display styles of list items?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
List out the oracle forms configuration files?
suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?
What are the types of trigger actions?
What is a user exit program in oracle reports?