Article View: cn.bbs.comp.database
Article #8516Re: һ��������
From: ����һ���������ڵ���ʱ
Date: Sun, 16 Nov 2003 15:09
Date: Sun, 16 Nov 2003 15:09
16 lines
1494 bytes
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��������ߵİٷֱ�,��ô���� -- [0;1;40;36m�� ��Դ:����ˮ˼Դվ bbs.sjtu.edu.cn��[FROM: 202.112.26.39][23;1H [m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.193.179.91][m
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!SJTUShow 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