1

When i tried to execute this statement:

 select salary,DEPARTMENT_ID from  EMPLOYEES  order by 1 fetch first 15 rows only;

I got an error as follows:

ORA-00933: SQL command not properly ended

I executed this in SQL Developer (17.3.1), if that matters.

Improve this question
3
  • 2
    What version of Oracle is your database on? The client and version of that shouldn't matter (esp. as you're using the current version of SQL Developer). The database server version does matter though. Commented Nov 16, 2017 at 17:53
  • 4
    Please run this command: select * from v$version; and append it's result to the question. My guess is that a version of your database is earlier than 12c, but this clause fetch first ... was introduced in 12c and it doesn't work in earlier versions. Commented Nov 16, 2017 at 17:59
  • As others have pointed out: the version of the SQL client is irrelevant because the SQL is executed by the server - and the version of that matters Commented Nov 16, 2017 at 20:36
Related questions
1394
How do I limit the number of rows returned by an Oracle query after ordering?
4
Limiting returned record from SQL query in Oracle
4
How to limit the number of records returned by an ORACLE query?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.