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

how to eliminate duplictes in column except group and
section?

Answer Posted / jagan

delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are bind variables?

1017


List the different types of columns in oracle reports.

937


did u received a single file or multiple files

1971


Can we invoke one form from another in a multi-forms application?

1068


suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1984


how do u place it in required folder

1868


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1850


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2919


What is an SQL FORMS ?

2717


What is the difference between bind and lexical parameter?

1010


How can we expand Parameter Form Canvas on Reports 6i?

2365


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2251


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1171


i am writing a query select EmpNo from Emp how can i call in after parameter form

2048


Is it possible to have multiple layouts in a report?

967