Article View: cn.bbs.comp.database
Article #703Re: ��һ��SQL����
From: Dem����ɫ�н�����
Date: Mon, 08 Dec 2008 04:48
Date: Mon, 08 Dec 2008 04:48
41 lines
1719 bytes
1719 bytes
���������� Table1: ID date 1 2008-01-01 2 2008-01-02 3 2008-01-01 Table2: ID Sub-ID Unit Data 1 11 111 20 2 22 222 10 3 33 333 60 1 44 444 40 ��ѯ���: SELECT t2.Unit, SUM(t2.Data) as SumData FROM [TestDB5].[dbo].[Table1] t1 inner join [TestDB5].[dbo].[Table2] t2 on t1.ID=t2.ID where t1.date between '2008-1-1' and '2008-2-1' group by t2.Unit GO ���: Unit SumData 111 20 222 10 333 60 444 40 �� �� enjoysoft (EnjoySoft Inc.) �Ĵ������ᵽ: �� : ��֪�������ֶ� ID(����)��date����ʾ���ڣ� : �ӱ���ID�����Sub-ID��Unit��Data : ϣ����Unit����ͳ��Data���ܺͣ����Ұ���dateɸѡ����...��...�� : SELECTӦ�����д�أ�лл�� -- http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg [m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30][m
Technical Details
Message-ID:
<4dMEk1$bKX@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,746678806c8c3391 X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����) Newsgroups: cn.bbs.comp.database Subject: Re: ��һ��SQL���� Date: 08 Dec 2008 04:48:11 GMT Organization: ��ˮ˼Դ Message-ID: <4dMEk1$bKX@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1228711585.A