Article View: cn.bbs.comp.database
Article #194Re: SQL���
From: Dem����ɫ�н�����
Date: Sat, 25 Jul 2009 04:49
Date: Sat, 25 Jul 2009 04:49
22 lines
1562 bytes
1562 bytes
���Ҫ����ͨ����ʵ�֡���������Ϊ��Ҫ���еرȶ��Ƿ�һ�����Ի���cursorЧ�ʱȽ� ��һЩ������ ǰ����Ҳ�и�����������Ϊ��һ���Ե��벻��Ҫ���ܴ����Ż�����������temp table����group by+count(*)�ģ�Ч�ʿ϶�����ô���� �� �� zichuan (MSSQL�ǵ���רҵ�����) �Ĵ������ᵽ: �� : col1 col2 : -------------------- : 1 a : 1 b : 2 c : -------------------- : �����õķ����õ� : 1 a,b : 2 c : ����cursor,лл -- http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg [m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.145.142][m
Technical Details
Message-ID:
<4h9ALJ$biZ@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,399cf34f544e6437,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!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����) Newsgroups: cn.bbs.comp.database Subject: Re: SQL��� Date: 25 Jul 2009 04:49:17 GMT Organization: ��ˮ˼Դ Message-ID: <4h9ALJ$biZ@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1248497155.A Lines: 21