Re: access ��ѯ��select * from( select ...)��÷��

Article View: cn.bbs.comp.database

Article #254

Back to cn.bbs.comp.database Previous Next

#254

From: Dem��ɫ�н��
Date: Wed, 10 Jun 2009 11:13

19 lines
1724 bytes

��Ϊsql��ȷû������,�﷨��ȷ
access�﷨�Ͳ��϶���...ʵ�ڲ��з���������
�� �� buada (С��) �Ĵ������ᵽ: ��
: ��һ����  �ͻ� ������  �����
:           A     001    0011
:           A     001    0012
:           A     002    0021
:           B     003    0032
: һ���ͻ������ж�������ţ�һ�������Ŷ�Ӧ�ж�������
: ����SQL��ѯ���
: SELECT [2009-01].�ͻ�, count([2009-01].������) as count
: FROM [2009-01]
: GROUP BY [2009-01].�ͻ�, [2009-01].������;
: .................������ʡ�ԣ�

--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg

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

Technical Details

Message-ID: <4gMCkc$aqb@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!feeder.news-service.com!feeds.phibee-telecom.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 4df683fd51,da8433695d654071,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!feeder.news-service.com!feeds.phibee-telecom.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU
From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����)
Newsgroups: cn.bbs.comp.database
Subject: Re: access ��ѯ��select * from( select ...)���÷���
Date: 10 Jun 2009 11:13:42 GMT
Organization: ��ˮ˼Դ
Message-ID: <4gMCkc$aqb@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1244632262.A
Lines: 19

Article View: cn.bbs.comp.database

Re: access ��ѯ��select * from( select ...)���÷���

Re: access ��ѯ��select * from( select ...)��÷��