Re: ��

Article View: cn.bbs.comp.database

Article #8365

Back to cn.bbs.comp.database Previous Next

#8365

From: ��
Date: Thu, 27 Nov 2003 00:48

20 lines
1578 bytes

   SQL> select rownum rank,sal from (select sal from emp order by sal desc )
 b where rownum < 6;
      RANK        SAL
---------- ----------
         1       5000
         2       3000
         3       3000
         4       2975
         5       2850
SQL> 

�� �� OMEGA.bbs@bbs.nankai.edu.cn (���ں������º���) �Ĵ������ᵽ: ��
: ��Ҫ����Ǻü�����¼��
: �Ȱ������¼����id��СORDER BY ID DESC���У�
: Ȼ����WHERE ROWNUM<5��������������������¼��


--
[m[1;36m�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 61.149.132.137][m

Technical Details

Message-ID: <49QBZG$Zu0@bbs.pku.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news.eunet.no!uio.no!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newshosting.com!news-xfer2.atl.newshosting.com!diablo.voicenet.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.happynet.org!PKU

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
X-Google-Thread: 101948,53bac50bef4ad472
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-11-26 16:49:05 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news.eunet.no!uio.no!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newshosting.com!news-xfer2.atl.newshosting.com!diablo.voicenet.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.happynet.org!PKU
From: maghaen@bbs.pku.edu.cn (�������)
Newsgroups: cn.bbs.comp.database
Subject: Re: ����
Date: 27 Nov 2003 00:48:57 GMT
Organization: ����δ��վ
Message-ID: <49QBZG$Zu0@bbs.pku.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Database/M.1069894048.A
Lines: 20

Article View: cn.bbs.comp.database

Re: ����

Re: ��