hi.. Try "group by" in ur query. Regards, Anitha
On Mon, Aug 3, 2009 at 4:35 PM, Hemant Sonawane <hemant.sonawan...@yahoo.com > wrote: > > > Hi, > I want fetch distinct record from table. > If any one have please let me know. > > > Ex.. > > > I have one table “*ProdTable*” in this table number of field is there, out > of those one field name is “*WrkCtrId*”, so data in this table is as like > this.. > > > > * * > > *TmpAProd.WrkCtrId* > > Line A > > Line B > > Line A > > Line C > > Line D > > Line B > > > > In this table total number of row is 6. But I want distinct result from > this row is 4 (is in red color). > > So please kindly give me solution if u have… > > > > Thanks & Regards > > Hemant Sonawane. > > 9922 947 479 > > >