SQL error while using limit keyword in Derby

Question

I have used limit keyword as:

"select * from empl3 limit "+4

But I am getting the error as:

Syntax error: Encountered "4" at line 1, column 27.

I am using Derby database.

Answer 1

As documented in the manual there is no LIMIT clause in Derby.

Derby uses the SQL standard for limiting the number of rows:

select * 
from empl3 
fetch first 4 rows only;