Re: ÿ��һ��

Article View: cn.bbs.comp.database

Article #982

Back to cn.bbs.comp.database Previous Next

#982

From: Galaxy��VOLUNTEERS
Date: Wed, 17 Sep 2008 02:11

29 lines
1574 bytes

sql server�в�����ô�鷳��:

select
ROW_NUMBER() OVER(ORDER BY [col2] desc) as rownum,
[col1],
[col2]
FROM [TestDB1].[dbo].[TestTable2]

�� �� trumy (ְҵɱ��@������ˮ) �Ĵ������ᵽ: ��
: select rownum,col1,col2 from 
: (select col1,col2 from testdb1.dbo.testtable2 order by col2 desc) t
: �� �� Dem �Ĵ������ᵽ: ��
: : �����ҳ��ͳ����򵥵ĺ���
: : ��ṹ����:
: : SELECT 
: : [col1]
: : ,[col2]
: : FROM [TestDB1].[dbo].[TestTable2]
: : ����col2�Ӵ�С����,��ÿ������һ�������к�


--
I thought what I'd do was, I'd pretend I was one of those deaf-mutes
Or should I?

You know what I��d like to be? I mean if I had my goddam choice, I��d just be
the catcher in the rye and all.

[m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.27][m

Technical Details

Message-ID: <4c67hf$b0W@bbs.sjtu.edu.cn>

Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,2125c4b1ef07e486,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS)
Newsgroups: cn.bbs.comp.database
Subject: Re: ÿ��һ��
Date: 17 Sep 2008 02:11:09 GMT
Organization: ��ˮ˼Դ
Message-ID: <4c67hf$b0W@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1221617465.A