I don't understand why oracle doesn't have something like LIMIT x,x liek
there is in MySQL... any ideas?
Norbert Biermayr wrote:
> The following query shows a right result:
>
> "Select Nummer From Artikel where Nummer > 60000 and Rownum < 2 Order by Nummer"
>
> The result is the correct number 60001.
>
> With the statement
>
> "Select * From Artikel where Nummer > 60000 and Rownum < 2 Order by Nummer"
>
> I get a wrong result: Number 68048.
>
> Has anyone an explanation for this behavior?
>
> We are using Oracle 9. The table "Artikel" is indexed with
> a constraint for the field "Nummer".
Received on Thu Jan 13 2005 - 13:57:19 CST
