Article View: cn.bbs.comp.database
Article #8517Re: һ��������
From: Խ��ԽԶ
Date: Sun, 16 Nov 2003 15:07
Date: Sun, 16 Nov 2003 15:07
17 lines
1424 bytes
1424 bytes
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��������ߵİٷֱ�,��ô���� -- �Ұ��Ұ��� �ҵ�һ�������� ������,������ �����ҵĺ����� [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.15.34][m
Technical Details
Message-ID:
<49I5R4$buc@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer2.atl.newshosting.com!167.206.3.103.MISMATCH!news3.optonline.net!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!newshosting.com!news-xfer2.atl.newshosting.com!167.206.3.103.MISMATCH!news3.optonline.net!news.bylinux.net!news.ccie.net.cn!SJTU From: jawahh.bbs@bbs.sjtu.edu.cn (Խ��ԽԶ) Newsgroups: cn.bbs.comp.database Subject: Re: һ�������� Date: 16 Nov 2003 15:07:53 GMT Organization: ��ˮ˼Դ Message-ID: <49I5R4$buc@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1068995092.A Lines: 17