Article View: cn.bbs.comp.database
Article #1300Re: ����sql��ѯ����õ�����ֵ
From: ���幫��
Date: Wed, 17 Oct 2007 15:27
Date: Wed, 17 Oct 2007 15:27
27 lines
2109 bytes
2109 bytes
Ŷ
select max(...)
from ...
select ave(..)
from...
where...
group by ...
�� �� Fizban (��װ��Ϳ���Ϸ�ʦ) �Ĵ������ᵽ: ��
: ����ֻ�ܵõ��ɼ������ֵ�ɣ�
: ��������ƽ��ֵ����ֵ����
: �� �� liusuifeng (���幫��) �Ĵ������ᵽ: ��
: : select max(...)
: : from...
: : where...
: : group by...
: : .................������ʡ�ԣ�
--
[1mliusuifeng [0;37m([1;33m���幫��[0;37m) ����վ [1;32m1146[0;37m �� ����[[1;32m666[37m]�� [[36m��Ы��[0;37m] [m
�� �� ��: [[1;32m2007��04��24��02:00:50 ���ڶ�[0;37m] �� [[1;32m58.196.153.53[0;37m] ����վһ�Ρ� [m
Ŀǰ���ߣ�[[1;32mѶϢ����([36m��[32m) ��������([36m��[32m)[0;37m] ������:[[1;32m364[0;37m] ����:[[1;32m2222[0;37m] ����:[[5;1;32m [m
ְ��: [[1;33mIQ Emprise [32m�����[37m] [m
Ŀǰ liusuifeng ״̬���£�
[1m��ѯ���� [0;37m [1mWeb ��� [0;37m [m
[m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.196.153.53][m
Technical Details
Message-ID:
<4WW4TM$bid@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!news.mixmin.net!news.buerger.net!news.bbh.net.cn!bbsnews.sdu.edu.cn!SJTUBBSShow 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!news3.google.com!proxad.net!feeder1-2.proxad.net!news.mixmin.net!news.buerger.net!news.bbh.net.cn!bbsnews.sdu.edu.cn!SJTUBBS From: liusuifeng.bbs@bbs.sjtu.edu.cn (���幫��) Newsgroups: cn.bbs.comp.database Subject: Re: ����sql��ѯ����õ�����ֵ Date: 17 Oct 2007 15:27:04 GMT Organization: ��ˮ˼Դ Message-ID: <4WW4TM$bid@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1192634758.A