Article View: cn.bbs.comp.lang.visual-basic
Article #20755Re: ����SQL��ѯ��һ�ʣ�����ش�
From: �ɰ�������
Date: Thu, 31 Jul 2003 13:07
Date: Thu, 31 Jul 2003 13:07
21 lines
1806 bytes
1806 bytes
˭�ش������ҵ����Ⱑ~~ �� �� flyrabbit (�ɰ�������) �Ĵ������ᵽ: �� : ��һ���?��a,b,c,d,e�����ֶΣ������avg(a) as avga group : by e��b,c,d ѡ��������Ϊһ����ʱ�ļ�¼�С�����e��ֵ��ͬ�Ļ��� : ��b,c,d��ֵҲ��ͬ�������ѡ��������ݱ�������ʾ����ָ��һ�¡� : һ������������д�ģ�������ô�ģ�лл������ : lstrSQL = "" : lstrSQL = lstrSQL & "Select avg(a)as avgdangliang Group by e," : lstrSQL = lstrSQL & "b," : lstrSQL = lstrSQL & "c," : lstrSQL = lstrSQL & "d" : lstrSQL = lstrSQL & "From ** " : lstrSQL = lstrSQL & "Where [e] = '" & _ : ................... -- ���ҵ�è�д���ȥ��ѩ������ [m[1;36m�� ��Դ:��BBS ˮľ�廪վ smth.org��[FROM: 211.80.32.6][m
Technical Details
Message-ID:
<000000$60i@smth.org>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!SMTHShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 109fdd,5ee8755e6c12db2b X-Google-Attributes: gid109fdd,public X-Google-ArrivalTime: 2003-07-31 06:10:14 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!SMTH From: flyrabbit@smth.org (�ɰ�������) Newsgroups: cn.bbs.comp.lang.visual-basic Subject: Re: ����SQL��ѯ��һ�ʣ�����ش� Date: 31 Jul 2003 13:07:40 GMT Organization: BBS ˮľ�廪վ Message-ID: <000000$60i@smth.org> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: VisualBasic/n/M.1059656843.W0 Lines: 21