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.

Answer Posted / samad

delete from emp a where rowid >(select min(rowid) from emp
b where a.rowid = b.rowid);
2. DELETE FROM EMP A
WHERE ROWID > ( SELECT min(ROWID) FROM EMP B WHERE
A.ROWID = B.ROWID)

cheers
samad

Is This Answer Correct ?    21 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can u give the Documentation of Custom.pll in oracle apps

3457


What is a value set? List its various types.

1080


In hierarchical structure of a database? we have write query from where we should start?

2224


What are the different components of soa suite?

1195


What are the Standard Reports and Forms in HRMS?

2288


Is soa a part of oracle fusion middleware?

1074


List the various types of value set.

1072


How many schemas we have? how many you have used?

2044


Do you know where we can check the status of po?

1256


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3020


what is the difference between request group and request security in oracle apps?

5870


How do you register report in oracle apps?

1081


how can i print random rows in plsql table

2475


can we get profile values in report without using user exists is it possible how?

2868


what is pay run id ?

2182