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 is choreography different from orchestration?

1101


tell me the scenarios of the independent in reports

2456


What is instead of trigger in where we will use?

1145


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

2199


What is oracle soa suite?

1194


how to print multi lay outs,muti currency,muti language in xml publisher

12195


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

2385


Do you know what is applysys in oracle application database schema, what is apps?

1154


what are the prerequisites for costing transactions?

3107


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2024


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

1034


What is a flexfield? List out its types.

1128


Can you differentiate between mediator and osb?

1104


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?

1043


What do you understand by a set of books?

1065