🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #8516

Re: һ��������

#8516
From: ����һ���������ڵ���ʱ
Date: Sun, 16 Nov 2003 15:09
16 lines
1494 bytes
ǿ��
�� �� jawahh (Խ��ԽԶ) �Ĵ������ᵽ: ��
: select (a.curValue-b.curValue)*100/b.curValue as percents form tab as a
: inner join tab as b on a.year=b.year+1
: �� �� cowboys (������~~����) �Ĵ������ᵽ: ��
: : ��һ����tab��curValue,year �ֶ�
: : ��  curValue year
: :     2000     1998
: :     2345     1999
: :     2456     2000
: : ������sql���д��ÿ��curValue��������ߵİٷֱ�,��ô����


--
�� ��Դ:����ˮ˼Դվ bbs.sjtu.edu.cn��[FROM: 202.112.26.39]
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.193.179.91]
Technical Details
Message-ID: <49I5W9$c0g@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!c03.atl99!sjc70.webusenet.com!news.webusenet.com!news.bylinux.net!news.ccie.net.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,9b093ad37b189be7
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-11-16 07:06:16 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!c03.atl99!sjc70.webusenet.com!news.webusenet.com!news.bylinux.net!news.ccie.net.cn!SJTU
From: hongliang.bbs@bbs.sjtu.edu.cn (����һ���������ڵ���ʱ)
Newsgroups: cn.bbs.comp.database
Subject: Re: һ��������
Date: 16 Nov 2003 15:09:00 GMT
Organization: ��ˮ˼Դ
Message-ID: <49I5W9$c0g@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1068995337.A
Lines: 16