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
- Visit your group "binusnet" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
