Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Answers were Sorted based on User's Feedback



Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / koti

Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .

Is This Answer Correct ?    15 Yes 16 No

Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / madhuapps

delete from t1 tl
where tl.rowid >
( select min(tl2.rowID) from t1 tl2
where tl.col1 = tl2.col1
and tl.col2 = tl2.col2)

Is This Answer Correct ?    25 Yes 31 No

Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / satyan

simple query
step 1
select rowid,column1,column2,column3 from table name where
condition;
step 2
delete from table name where rowid = '........'

Is This Answer Correct ?    4 Yes 11 No

Write an SQL Query to Delete Duplicate records from a table using ROWID...

Answer / ganesh

delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );

Is This Answer Correct ?    14 Yes 24 No

Post New Answer

More Oracle Apps Technical Interview Questions

What are documents and test cases u followed.

2 Answers   Accenture,


what is the difference between oracle 8i and 9i?

1 Answers  


cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,


in GL module specifing org_id or not?

1 Answers  


What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,


Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,


what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,


How do u customize the Reports?

1 Answers  


In oracle application how do you debug or trace errors?

0 Answers  


HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,


What is SRW Package? (Sql Report Writer)

1 Answers  


Explain the multi-organization structure.

1 Answers   Accenture,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)