Article View: cn.bbs.comp.database
Article #412Re: sql server 2000�еķ�ҳ��ѯ
From: Galaxy��VOLUNTEERS��Database
Date: Wed, 29 Apr 2009 03:03
Date: Wed, 29 Apr 2009 03:03
21 lines
1864 bytes
1864 bytes
�����order by id desc�Ļ����п�������ҳ����ʾʱ˳���Ƿ��� ���������ŵ�Ȼ����ˣ�Ӧ�ö˷�ҳҲ�dz��õķ��� �� �� zichuan (����) �Ĵ������ᵽ: �� : select top 10 * from (select top 20 * from table order by id) as a : order by id desc : ���Ÿ��������Dz��Ǻõ�? : �������ID���й��ɵģ�ֱ�ӿ��� �� BETWEEN 10 AND 20 : �����ݲ���Ļ���ȫ����ȫ�������Ȼ��ͨ�� DataTable ��ҳȡ�� : �� �� clstn �Ĵ������ᵽ: �� : : ��sql server 2000�У���ѯijһ��Χ����ݣ����10������20�� : : �ɲ�����д���������ʽ�� : : select top 10 * from table : : where id not in ( : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 219.142.46.134][m
Technical Details
Message-ID:
<4fb9B6$aif@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.neu.edu.cn!news.newsmth.net!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,2467ddf570cf15f5,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!news.glorb.com!news2.glorb.com!news.neu.edu.cn!news.newsmth.net!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: sql server 2000�еķ�ҳ��ѯ Date: 29 Apr 2009 03:03:29 GMT Organization: ��ˮ˼Դ Message-ID: <4fb9B6$aif@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1240974102.A