Dear Eko, wah mas thx banget, setelah saya coba querynya udah bisa sampai gak kepikiran klo di aliasin. thx banget mas Eko
Regards, Krishna ________________________________ From: eko suprijantono <[email protected]> To: [email protected] Sent: Saturday, June 13, 2009 11:42:04 AM Subject: Re: [indo-oracle] Mohon bantuan masalah query... Dear Krishna, Cobain spt dibwh... select a.data,(a.data/ b.sumdata) from <table> a,(select sum(b.data) sumdata from <table> b where <where clause>) where <where clause> ____________ _________ _________ __ From: Raja Krishna <raja_...@yahoo. com> To: indo-oracle@ yahoogroups. com Sent: Friday, June 12, 2009 4:44:40 PM Subject: [indo-oracle] Mohon bantuan masalah query... mo minta tolong nih, gimana ya untuk membuat average dari sum coloumn. misal seperti ini, aku punya 4 record dari 1 table A No Data Hasil 1 2500 2 3200 3 400 4 5 dari sini aku mo select sehingga Field "Hasil" akan menghasilkan data seperti ini No Data Hasil 1 2500 0.40950041 2 3200 0.52416052 3 400 0.06552007 4 5 0.000819 dimana hasil dari record no: 1. rumusannya 2500 \ sum(data) 2. rumusannya 3200 \ sum(data) 3. rumusannya 400 \ sum(data) 4. rumusannya 5 \ sum(data) Atas bantuan temen2 saya ucapkan banyak terima kasih. thanks Regards, Krishna [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
