Article View: cn.bbs.comp.database
Article #827Re: [���]һ��sql������ôд
From: �����츮��ϲ���Ϻ�������
Date: Wed, 19 Nov 2008 03:10
Date: Wed, 19 Nov 2008 03:10
24 lines
1758 bytes
1758 bytes
timeCondition�Ƕ�����в���͵�ʱ�䶨�� SELECT Name,Date,sum(Price) FROM table WHERE name='xxx' and timeCondition group by Date mysql�²���ͨ�� �� �� WWF (WWF) �Ĵ������ᵽ: �� : �������и����⣬����һ����ݱ������� : Name��Price, Date, Time�ĸ��ֶ� : ÿ������������ٷ������п���ÿ�ٷ�������ֹһ�� : ������Ҫͳ��ÿ����ÿ����������ٻ��ѵ�ƽ�������ÿ����ͻ����٣���ͻ����� : ��������Щ�˿���һ����緹���ܲ�ֹ��һ�ο��� : �������������ôд�ſ��ԣ��Ҷ�sql��䲻�Ǻ��� : лл -- http://bbs.sjtu.edu.cn/file/Earthquake08/1210847676325670.gif [m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 116.232.64.188][m
Technical Details
Message-ID:
<4d7JjM$bKZ@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,cd25524f7035ca48 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-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!news.shec6.edu.cn!SJTU From: pax.bbs@bbs.sjtu.edu.cn (�����츮��ϲ���Ϻ�������) Newsgroups: cn.bbs.comp.database Subject: Re: [���]һ��sql������ôд Date: 19 Nov 2008 03:10:33 GMT Organization: ��ˮ˼Դ Message-ID: <4d7JjM$bKZ@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1227064198.A