Re: order by, rownum and more

>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 Received on Thu Aug 08 2002 - 14:56:40 CDT