Oracle 11g and SQL TOP query

oracle11g, sql

Solution

Oracle does not support `TOP`. Use `ROWNUM`

SELECT * FROM your_table
WHERE ROWNUM <= 5

SQLFiddle example

Problem

While using `SELECT TOP 5 * FROM SOMETABLE` gives me an error ORA-00923: FROM keyword not found where expected I am using Oracle 11g . I am aware of using `rownum` for doing the same thing but just wondering SQL TOP usage is not at all supported in Oracle ? Anything need to do extra to make SQL TOP working in Oracle ??

Original source