🚀 go-pugleaf

���������ѯ:
Select sum(Price) from Table1 where ID between b.ID and b.ID-4)/ 
iif(ID>5,5,ID)
����˼��:
���ID>5,�ͽ�ID-4��ID�еļ۸�Price�ܺͳ���5
���ID<=5,��ô�ͽ�1��ID�еļ۸�Price�ܺͳ�������(Ҳ����ID����ֵ)
ID��һ��������,�۸������Ҫ����ļ۸���� �� �� Dem 
(Galaxy ��VOLUNTEERS��Database) �Ĵ������ᵽ: ��: �������������Ϊ����
: ��ǰ����һ���?
: http://bbs.sjtu.edu.cn/file/database/124781641449192.jpg
: Ȼ��ʹ�����²�ѯ��
: SELECT ID, Price, (Select sum(Price) from Table1 where ID between b.ID and 
: b.ID-4)/ iif(ID>5,5,ID) AS MovingAvg
: FROM Table1 AS b;
: ������£�
: http://bbs.sjtu.edu.cn/file/database/124781643649390.jpg 
:  �� �� Cissnei (СC�Ů���ʹ��Smiling 
: .................������ʡ�ԣ�

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

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.27]