pake perintah gini aja select style from nama_tabel where style
in('CS~VH32','CR~VH12R');
semoga membantu..!!1
--- Pada Sel, 13/4/10, Freddie Tanuwijaya <[email protected]> menulis:
Dari: Freddie Tanuwijaya <[email protected]>
Judul: Re: [indo-oracle] tanya : Query nich!!
Kepada: [email protected]
Tanggal: Selasa, 13 April, 2010, 11:45 AM
Pake distinct aja bro
____________ _________ _________ __
From: abe ashfi <ashf...@yahoo. com>
To: indo-oracle@ yahoogroups. 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]
__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail.yahoo.com
[Non-text portions of this message have been removed]
