Oracle 11g OFFSET FETCH 给出错误 [英] Oracle 11g OFFSET FETCH gives error

问题描述

我正在查询并尝试从数据库中获取随机数量的行，但 Oracle 一直告诉我我的命令没有正确结束.

I am making a query and trying to fetch a random number of rows from a database but Oracle keeps telling me my command has not been ended properly.

select *
from random_table
order by random_column_name
offset 0 rows
fetch first 10 rows only

这是我正在使用的代码.

This is the code I'm using.

我将不胜感激任何支持，因为我花了相当多的时间为我得到的结果寻找解释，但无济于事.

I would greatly appreciate any support since I've spent quite some time searching for an explanation for the outcome I'm getting, but to no avail.

推荐答案

该语法直到 Oracle Database 12c 才有效.

That syntax isn't valid until Oracle Database 12c.

你会说

select *
from random_table
where rownum < 11
order by random_column_name;

这篇关于Oracle 11g OFFSET FETCH 给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！