Ok terima kasih bro Wadi. Maap nanya lagi nih.. Tools untuk compare cost dari pilihan query kita (tuning query) di oracle apa ya?
From: [email protected] [mailto:[email protected]] On Behalf Of Wadi Achmed Sent: Wednesday, June 23, 2010 9:12 PM To: [email protected] Cc: Akah; 'Aud Solehuddin' Subject: Re: [indo-oracle] ask query SQL Query dengan menggunakan UNION akan memakan proses filter lagi layaknya distinct. Sementara UNION ALL akan mengabaikan duplikat data dari masing blok query. Cheers, Wadi Achmed On 6/22/2010 6:18 PM, Akah wrote: > Yup setuju dengan bung Wadi, sebaiknya diperhatikan lagi normalisasinya. > > > > Oh iya kalau dibanding dengan > > > > SELECT * FROM > > (SELECT ID_COMPANY, CARA_BAYAR, BAYAR FROM HR.TABLE_A > > UNION SELECT ID_COMPANY, CARA_BAYAR, BAYAR FROM HR.TABLE_B > > UNION SELECT ID_COMPANY, CARA_BAYAR, BAYAR FROM HR.TABLE_C) X > > WHERE X.CARA_BAYAR='TUNAI' > > > > Costnya besaran mana ya bro? > > > > From: [email protected] <mailto:indo-oracle%40yahoogroups.com> [mailto:[email protected] <mailto:indo-oracle%40yahoogroups.com> ] On > Behalf Of Wadi Achmed > Sent: Tuesday, June 22, 2010 5:51 PM > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Cc: Aud Solehuddin > Subject: Re: [indo-oracle] ask query SQL > > > > > > Pertama: Maaf, saya balik nanya. > Kenapa tablenya ada 3 kalau atribut dan fungsinya sama semua? > > Solusinya: > > Kalau tablenya satu (nama table asumsi table_bayar): > ------------------------------ > Select id_company, bayar > from table_bayar > where cara_bayar = 'tunai'; > > Kalau masih maksa pake 3 table > ------------------------------ > select id_company, bayar > from table_a > where cara_bayar = 'tunai' > union all > select id_company, bayar > from table_b > where cara_bayar = 'tunai' > union all > select id_company, bayar > from table_c > where cara_bayar = 'tunai'; > > Sekali lagi saya sarankan diubah tablenya cukup satu aja. > Coba pelajari lagi konsep normalisasi database. > > Cheers, > Wadi Achmed > > On 6/22/2010 5:08 PM, Aud Solehuddin wrote: > >> Dear all, terimakasih sebelumnya, minta bantuan nyari query SQL untuk >> > select dari table berikut : > >> >> >> misal saya punya tiga table, >> >> >> >> table A >> >> id_company >> >> cara_bayar (tunai, bni, bca) >> >> bayar >> >> field lain2 >> >> >> >> table B >> >> id_company >> >> cara_bayar (tunai, bni, bca) >> >> bayar >> >> field lain2 >> >> >> >> table C >> >> id_company >> >> cara_bayar (tunai, bni, bca) >> >> bayar >> >> field lain2 >> >> >> >> contoh isian : >> >> table A >> >> >> >> PT Coba >> >> 200000 >> >> tunai >> >> >> >> table B >> >> PT Tes >> >> 500000 >> >> bni >> >> >> >> table C >> >> PT Sample >> >> 1000000 >> >> tunai >> >> >> >> hasil yang diharapkan (tampil yang tunai) : >> >> >> >> id_company bayar >> >> PT Coba 200000 >> >> PT Sample 1000000 >> >> >> >> bagaimana cara saya menampilkan id_company dan bayar, yang memiliki cara >> > bayar ='tunai' > >> >> >> makasih atas bantuannya semuanya.. :) >> >> >> >> >> >> [Non-text portions of this message have been removed] >> >> >> >> ------------------------------------ >> >> -- >> -----------I.N.D.O - O.R.A.C.L.E--------------- >> Keluar: [email protected] <mailto:indo-oracle-unsubscribe%40yahoogroups.com> >> > <mailto:indo-oracle-unsubscribe%40yahoogroups.com> > >> 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] > > > > > > Please consider the environment before print out this email > =================================================================== > ==This message was scanned by Toyota Tsusho Indonesia Email Server Anti Virus== > =================================================================== > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] <mailto:indo-oracle-unsubscribe%40yahoogroups.com> > 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 > > > > > Please consider the environment before print out this email =================================================================== ==This message was scanned by Toyota Tsusho Indonesia Email Server Anti Virus== =================================================================== [Non-text portions of this message have been removed]
