select min(style) from <<namatable>> group by substr(style,1,7)
kalau kurang tepat mohon dimaapkan, maklum nyubi --- On Wed, 4/14/10, Rudy W Sitanggang <[email protected]> wrote: From: Rudy W Sitanggang <[email protected]> Subject: Re: [indo-oracle] tanya : Query nich!! To: [email protected] Date: Wednesday, April 14, 2010, 10:19 AM atau buat table mapping saja antara data barang dan style, kalo emang barang bisa punya style yang macem macem. 2010/4/13 Freddie Tanuwijaya <[email protected]> > > > Pake distinct aja bro > > ________________________________ > From: abe ashfi <[email protected] <ashfi60%40yahoo.com>> > > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Tue, April 13, 2010 10:44:46 AM > Subject: [indo-oracle] tanya : Query nich!! > > > Mau tanya dunk. > ak punya data sperti dibawah. > > Style > ===== > CS~VH32 > CS~VH32T > CS~VH32R > CR~VH12R > CR~VH12RR > CR~VH12RT > > ak pgn select dan hasilnya sperti ini > > Style > ===== > CS~VH32 > CR~VH12R > > karena dari data yang ak punya itu 2 barang yg sama tapi beberapa digit > dari kode style itu yg membedakan. > > mungkin ada yg bisa bantu. > terimakasih > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > -- Warm regards, Rudy Wardhany Yahoo ID: [email protected] [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links [Non-text portions of this message have been removed]
