Re: [BinusNet] SQL challenge: average every n rows

Wed, 24 May 2006 23:02:41 -0700

oi HW .. long time no see :D

hasil yg diinginkan kok aneh? apa bener kayak gini:

1 (ave dr row num 1,2,3 = 1+1+1 / 3 = 1)
2 (ave dr row num 4,5,6 = 2+2+2 / 3 = 2)
3 (ave dr row num 7,8,9 = 3+3+3 / 3 = 3)

hasil di atas ga salah ketik? atau mungkin maksudnya gini:

1 (ave dr row num 1,2,3 = 1+2+3 / 3 = 2)
2 (ave dr row num 4,5,6 = 4+5+6 / 3 = 3)
3 (ave dr row num 7,8,9 = 7+8+9 / 3 = 8)

kalo yg ini querynya adalah:

select value, (select sum(num) / (select count(value) from mytable where
value = a.value) from mytable where value = a.value) as ave
from mytable a group by value

CMIIW

kalo hasil yg diinginkan emang seperti yg diketik, mungkin bisa di modif
juga dari query diatas. hope it helps


Rgds,
jn

----- Original Message -----
From: "Humphrey Widjaja" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: 25 May 2006 11:50
Subject: [BinusNet] SQL challenge: average every n rows


Hi Friends,

g ada pertanyaan ttg SQL nih, g mo query ke SQL Server (Sybase) yg
bisa average setiap n rows.

Sbg ilustrasi, misalnya g punya table (myTable) dengan column num and value

myTable:
num value
1 1
2 1
3 1
4 2
5 2
6 2
7 3
8 3
9 3

G mau query yg hasilnya:

1 (ave dr row num 1,2,3 = 1+1+1 / 3 = 1)
2 (ave dr row num 4,5,6 = 2+2+2 / 3 = 2)
3 (ave dr row num 7,8,9 = 3+3+3 / 3 = 3

Selain select all row and process in the script, apakah ada select
statement / T-SQL / cara lain untuk query?

Regards,

Humphrey







BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan
Moderator BinusNet : Suryadi Liawatimena & Surya Iskandar


Stop or Unsubscribe: send blank email to [EMAIL PROTECTED]
Questions or Suggestions, send e-mail to [EMAIL PROTECTED]

-=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-=
Bina Nusantara mempersembahkan
25 Tahun Bersama Binus untuk Indonesia
1981 - 2006

Venue: Plenary Hall, Jakarta Convention Center
Date : 25 February 2006
-=-=-=-=-=-=-=-=-=-=--==-=--==-=-=--=-=-=-=-=-=



SPONSORED LINKS
Bali indonesia hotel Bali indonesia Indonesia hotel
Bali indonesia vacation Bali indonesia travel

YAHOO! GROUPS LINKS



Kirim email ke