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 / murugaraj.g

HERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1069


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

2069


What are do's and dont's of Interface?

2433


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

2320


How can we import the data into a database using sql * loader?

1196


where to define interorganization transaction charges and what are the different options?

2425


What is the concept of soa governance?

1256


How is choreography different from orchestration?

1140


How do you register report in oracle apps?

1100


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2619


what are the balancing segments in AR?

2103


What are the Standard Reports and Forms in HRMS?

2321


what is global tempory table?

7222


is it possible to run the interface without using oracle apps?

1986


What do you understand by a set of books?

1118