Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!bigboote.WPI.EDU!grover.wpi.edu!rudie
From: Brian Murphy <rudie@wpi.edu>
Newsgroups: comp.databases.oracle.misc
Subject: Re: order by, rownum and more
Date: Thu, 8 Aug 2002 15:56:40 -0400
Organization: Worcester Polytechnic Institute
Lines: 15
Message-ID: <Pine.OSF.4.43.0208081555040.16287-100000@grover.WPI.EDU>
References: <Pine.OSF.4.43.0208081455040.12797-100000@grover.WPI.EDU>
 <LEz49.13$wl2.180@news.oracle.com>
NNTP-Posting-Host: grover.wpi.edu
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Trace: bigboote.WPI.EDU 1028836602 18142 130.215.25.67 (8 Aug 2002 19:56:42 GMT)
X-Complaints-To: abuse@wpi.edu
NNTP-Posting-Date: Thu, 8 Aug 2002 19:56:42 +0000 (UTC)
In-Reply-To: <LEz49.13$wl2.180@news.oracle.com>
Xref: easynews comp.databases.oracle.misc:85339
X-Received-Date: Thu, 08 Aug 2002 12:53:47 MST (news.easynews.com)

>select c1, c2, c3
>  from ( select c1, c2, c3, rownum r
>              from ( select c1, c2, c3
>                          from T order by b ) )
> where r = 6

Ah yes, very helpful, that's exactly what I was looking for.

To respond to the others, after having done my order by, I have
essentially a 6th column, which now has meaning as the 6th.

thanks.

brian