🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #1301

Re: ����sql��ѯ����õ�����ֵ

#1301
From: ��װ��Ϳ���Ϸ�ʦ
Date: Wed, 17 Oct 2007 16:31
21 lines
1450 bytes
��л������ѧ�ڸտ�ʼѧ���ܶ��﷨���������
������ϸ����max()��������ʲô��������ֱ�Ӷ�avg()�Ľ����max�ɣ�


�� �� liusuifeng (���幫��) �Ĵ������ᵽ: ��
: Ŷ
: select max(...)
: from ...
:     select ave(..)
:     from...
:     where...
:     group by ...
: �� �� Fizban (��װ��Ϳ���Ϸ�ʦ) �Ĵ������ᵽ: ��
: : ����ֻ�ܵõ��ɼ������ֵ�ɣ�
: : ��������ƽ��ֵ����ֵ����


--
http://bbs.sjtu.edu.cn/file/DnD/1190969291216880.jpg 

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.56.206]
Technical Details
Message-ID: <4WW6Ah$bid@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.szu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBS

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,c358a5cfc57fdec4
X-Google-Attributes: gid101948,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.szu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBS
From: Fizban.bbs@bbs.sjtu.edu.cn (��װ��Ϳ���Ϸ�ʦ)
Newsgroups: cn.bbs.comp.database
Subject: Re: ����sql��ѯ����õ�����ֵ
Date: 17 Oct 2007 16:31:43 GMT
Organization: ��ˮ˼Դ
Message-ID: <4WW6Ah$bid@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1192638475.A