Article View: cn.bbs.comp.database
Article #373Re: ��������һ��SQL����ִ��˳��
From: Dem����ɫ�н�����
Date: Thu, 12 Mar 2009 13:15
Date: Thu, 12 Mar 2009 13:15
22 lines
1498 bytes
1498 bytes
��set showplan_all��֪����
ִ�е���䣺
SELECT top 5 [Item] ,[nesting level] ,[sort] FROM
[TestDB1].[dbo].[tblTest2] order by Item desc
|--Sort(TOP 6, ORDER BY:([TestDB1].[dbo].[tblTest2].[Item] DESC))
|--Table Scan(OBJECT:([TestDB1].[dbo].[tblTest2]))
��������order by��ѡ��Top 6
�� ��
haorenzk ( ����) �Ĵ������ᵽ: ��: SELECT top 6
: num,usersname,fplace
: FROM usermain
: WHERE fgroupno=1
: ORDER BY fplace
: �����ʵ��ǣ��˾��Dz�����ORDER BY�ź���֮����ѡ��ǰ6��������select��order by
--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg
[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.28][m
Technical Details
Message-ID:
<4f019C$bqh@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news.isoc.lu!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,b22b2f5ef9a6d430,start X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news.isoc.lu!news.shec6.edu.cn!SJTU From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����) Newsgroups: cn.bbs.comp.database Subject: Re: ��������һ��SQL����ִ��˳�� Date: 12 Mar 2009 13:15:33 GMT Organization: ��ˮ˼Դ Message-ID: <4f019C$bqh@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1236863676.A