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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can a process be deployed in soa?

1165


What do you understand by soa and what are the benefits of using this architecture?

1029


Do you know what are user profiles in apps. Any examples you can give?

1043


A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

2193


Can you explain the difference between architecture followed in 10g & 11g?

1020


what are the balancing segments in AR?

2042


what are the prerequisites for costing transactions?

3096


What is oracle soa suite and what are its different components?

1137


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

3424


tell me the scenarios of the independent in reports

2564


how do you describe O2C along with tables

2727


tell my any difficult situtation you solved in your experience in your company?

2283


How to move the one file from one instance to another instance? And your scripts also?

1073


Plz anybody send me Technical specification for AP Interface

2506


List the types of flexfield?

993