Article View: cn.comp.database.mysql
Article #87��̣��������ͳ�Ƶ�sql�����ôд��лл��
From: MichaelSun
Date: Fri, 26 Nov 2004 10:14
Date: Fri, 26 Nov 2004 10:14
11 lines
1449 bytes
1449 bytes
��ṹΪ�� execute_date date
items varchar(30)
costs int
��ͳ��ÿ�ա�ÿ����Ŀ�����룺
��д���ǣ�select execute_date, item, sum(costs)
FROM item
group by execute_date, item
order by execute_date
��ʾ�Ľ��ͬһ��Ļͣ�ͬһ����Ŀ���ֳ������У���֪��ʲôԭ�������ʹ��
ÿ��ֻ��һ�У�
лл��
Technical Details
Message-ID:
<co6un1$1bk2$1@mail.cn99.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 114450,e40ceb61a97ab116,start X-Google-Attributes: gid114450,public X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!not-for-mail From: "MichaelSun" <fantacysun@tom.com> Newsgroups: cn.comp.database.mysql Subject: ��̣��������ͳ�Ƶ�sql�����ôд��лл�� Date: Fri, 26 Nov 2004 18:14:17 +0800 Organization: Bentium Ltd. (CN99) Lines: 14 Message-ID: <co6un1$1bk2$1@mail.cn99.com> NNTP-Posting-Host: 218.24.187.149 X-Trace: mail.cn99.com 1101463073 44674 218.24.187.149 (26 Nov 2004 09:57:53 GMT) X-Complaints-To: usenet@news.cn99.com NNTP-Posting-Date: Fri, 26 Nov 2004 09:57:53 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106