Re: Unexpected result from simple query

"Can" <no_at_spam.net> wrote in

> To my astonishment, the following query doesn't limit the resultset as
> desired:
>
> SELECT columnA, columnB, RN
> FROM (
> SELECT columnA, columnB, ROWNUM RN
> FROM mytable
> )
> WHERE RN BETWEEN 4 AND 12;
>
> If I'm not completely mistaken this used to work.

Yeah, but it does not work in Oracle 6 on a cluster of ZX Spectrums.

--
Billy
PS. In case you don't get - Oracle version and platform are two
critical pieces of data that *always* must accompany a question like
yours.