🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #10206

Re: ���һ��SQL�ļ�����

#10206
From: fat man
Date: Sat, 04 Apr 1998 00:00
25 lines
1279 bytes
�� �� limodou (modou) �Ĵ������ᵽ: ��
: �� �� Roc (Roc) �Ĵ������ᵽ: ��
: : ����Delphi��һ����ݿ�ͳ�Ƴ���
: : ������һ��С�鷳��
: :         SELECT Username , SUM( size )
: :         FROM   MYDB
: :         GROUP  BY SUM( size )
: :         ORDER  BY SUM( size )
: : �����ҵõ���һ������Ľ��
: : ��������ֻҪǰʮ����¼�������
: : ���ͨ��SQL���ʵ�֣�
: : thx
: ��������ִ����? �

Simple,
set rowcount 10
then you may start your query
after your query
set rowcount 0

the query can be executeed by SYBASE but can not executed by MSSQL

--
�� ��Դ:���������� BBS bbs.nease.net��[FROM: ppp41.shenzhen.]
Technical Details
Message-ID: <3NkSG7$VGI@bbs.nease.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,98b922aaaf001ee6
X-Google-Attributes: gid101948,public
From: szshigw.bbs@bbs.nease.net (fat man)
Subject: Re: ���һ��SQL�ļ�����
Date: 1998/04/04
Message-ID: <3NkSG7$VGI@bbs.nease.net>
X-Deja-AN: 340706481
X-Filename: DataBase/M.891657991.A
Organization: Net Ease
Newsgroups: cn.bbs.comp.database,