Article View: cn.bbs.comp.database
Article #261Re: access ��select * from( select ...)���÷���(
From: Galaxy��VOLUNTEERS��Database
Date: Sat, 13 Jun 2009 06:33
Date: Sat, 13 Jun 2009 06:33
20 lines
1840 bytes
1840 bytes
�ҵ���Ҳ�Dz鵽��֧����ʱ�����벻������취��...Access��������ࡣ���� �� �� xiyuewang (����ѩ���Ұ�����) �Ĵ������ᵽ: �� : ������˼��access��֧����ʱ�?��Ҳ�����Ƚ��?ʹ�ú���ɾ�� : conn.execute "create table tbl(�ͻ� NVARCHAR(50), ������ NVARCHAR(50))" : conn.execute "insert into tbl : select distinct [2009-01].�ͻ�,[2009-01].������ from [2009-01]" : conn.execute "SELECT T1.�ͻ�, count(T1.������) as count : FROM tbl as T1 : GROUP BY T1.�ͻ�, T1.������" : conn.execute "drop table tbl" : access���Ǻ���Ϥ�����ܻ�������� : �� �� buada �Ĵ������ᵽ: �� : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.144.168][m
Technical Details
Message-ID:
<4gOMBL$cCf@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,7494e660b7b6038,start X-Google-Attributes: gid4df683fd51,public,usenet X-Google-NewGroupId: yes X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: access ��select * from( select ...)���÷���( Date: 13 Jun 2009 06:33:55 GMT Organization: ��ˮ˼Դ Message-ID: <4gOMBL$cCf@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1244874789.A