Re: ��ô��spl��ƶ�ƽ��

Article View: cn.bbs.comp.database

Article #171

Back to cn.bbs.comp.database Previous Next

#171

From: Galaxy��VOLUNTEERS��Database
Date: Fri, 17 Jul 2009 07:16

20 lines
1647 bytes

��Ȼ����ר����Ե�KB������
SELECT AutoNum, Price, (Select sum(Price) from qryRankRecords where Rank 
between b.Rank and b.Rank-4)/ iif(Rank>5,5,Rank) AS MovingAvg
FROM qryRankRecords AS b;
���ǲ�̫���Access��Ƕ�ײ�ѯ�ǲ��ǿ��ԡ�Ҫ�ǲ����ԵĻ�����ֻ�ܸ��ɱ���

 �� �� 
Programmer (12) �Ĵ������ᵽ: ��: ���ϲο��ܶ�
: http://www.access-programmers.co.uk/forums/showthread.php?t=37137
: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q143237
: �� �� Cissnei (СC�Ů���ʹ��Smiling Flying~) �Ĵ������ᵽ: ��
: : ʱ�����...5���ƽ��ֵ...


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

[m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.27][m

Technical Details

Message-ID: <4h32GO$bec@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news2.glorb.com!newsgate.cuhk.edu.hk!news.cn99.com!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 4df683fd51,cd44c281e07e426b,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news2.glorb.com!newsgate.cuhk.edu.hk!news.cn99.com!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��ô��spl���ƶ�ƽ��
Date: 17 Jul 2009 07:16:53 GMT
Organization: ��ˮ˼Դ
Message-ID: <4h32GO$bec@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1247814936.A

Article View: cn.bbs.comp.database

Re: ��ô��spl���ƶ�ƽ��

Re: ��ô��spl��ƶ�ƽ��