Kira-kira seperti ini query nya (kalau asumsi saya benar, style pembedanya cuma
1 karakter)
select distinct t1.style
from table_style t1, table_style t2
where t1.style = substr(t2.style,1,length(t2.style)-1) and
t1.style != t2.style
komen, design yang aneh.. seharusnya ada table master style yang memiliki
hirarki, atau kolom yang berisi style asalnya.
--
Regards,
Rudi Kristanto.
________________________________
From: Agus Tri Laksono <[email protected]>
To: [email protected]
Sent: Wednesday, April 14, 2010 17:31:57
Subject: Re: [indo-oracle] tanya : Query nich!!
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 <rudy.sitanggang@ gmail.com> wrote:
From: Rudy W Sitanggang <rudy.sitanggang@ gmail.com>
Subject: Re: [indo-oracle] tanya : Query nich!!
To: indo-oracle@ yahoogroups. com
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 <synar_0...@yahoo. com>
>
>
> Pake distinct aja bro
>
> ____________ _________ _________ __
> From: abe ashfi <ashf...@yahoo. com <ashfi60%40yahoo. com>>
>
> To: indo-oracle@ yahoogroups. com <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: rudy_staredge@ yahoo.com
[Non-text portions of this message have been removed]
------------ --------- --------- ------
--
-----------I. N.D.O - O.R.A.C.L.E- --------- -----
Keluar: indo-oracle- unsubscribe@ yahoogroups. com
Website: http://indooracle. wordpress. com
http://www.facebook .com/group. php?gid=51973053 515
------------ --------- --------- --------- --------
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]
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
