Article View: cn.bbs.comp.database
Article #10148Re: ���һ��SQL�ļ�����
From: Roc
Date: Tue, 07 Apr 1998 00:00
Date: Tue, 07 Apr 1998 00:00
20 lines
1096 bytes
1096 bytes
лл��ҵ�ӻԾ���� ��Ҳ���ֿ�����MS SQL ����Set Count�� �� �� szshigw (fat man) �Ĵ������ᵽ: �� : �� �� Roc (Roc) �Ĵ������ᵽ: �� : : thx szshigw : : but My query executed by MSSQL : MSSQL can also use set rowcount, : but it seemed that your own sql query block has : syntax error. : with group by statement, you should list all : your columes to be selected after your group by : orelse list them by min/max/count etc. (MSSQL) : SYBASE has no limit at using group by statement -- [m[1;34m�� ��Դ:���������� BBS bbs.nease.net��[FROM: 202.102.26.24][m
Technical Details
Message-ID:
<3O11Ck$UiP@bbs.nease.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,1a636ab29b8ddd74,start X-Google-Attributes: gid101948,public From: Roc.bbs@bbs.nease.net (Roc) Subject: Re: ���һ��SQL�ļ����� Date: 1998/04/07 Message-ID: <3O11Ck$UiP@bbs.nease.net> X-Deja-AN: 341605959 X-Filename: DataBase/M.891927406.A Organization: Net Ease Newsgroups: cn.bbs.comp.database,