Re: [��]һ��sql��ôд

Article View: cn.bbs.comp.database

Article #828

Back to cn.bbs.comp.database Previous Next

#828

From: ��츮��ϲ��Ϻ��
Date: Wed, 19 Nov 2008 03:44

19 lines
1392 bytes

    ��д���ǲ��Ҹ��˵ģ���name='xxx'�޶���
    �����ȫ���б?��ô��name='xxx'ȥ�� group������� name
    
�� �� OracleIOg (Oracle) �Ĵ������ᵽ: ��
: ȷ����
: Ӧ���� group by name��date
: �� �� pax �Ĵ������ᵽ: ��
: : timeCondition�Ƕ�����в���͵�ʱ�䶨��
: : SELECT Name,Date,sum(Price) FROM table WHERE name='xxx' and timeCondition 
: : group by Date
: : mysql�²���ͨ��


--

http://bbs.sjtu.edu.cn/file/Earthquake08/1210847676325670.gif 

[m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 116.232.64.188][m

Technical Details

Message-ID: <4d7Ke8$bCl@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!SJTU

Show 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.isoc.lu!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:44:57 GMT
Organization: ��ˮ˼Դ
Message-ID: <4d7Ke8$bCl@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1227066248.A

Article View: cn.bbs.comp.database

Re: [���]һ��sql������ôд

Re: [��]һ��sql��ôд