Search code examples
sqllimitjavadb

SQL Limit error with JavaDB

Firstly, I'm new to SQL - not so new to Java anymore.

Secondly, I'm using NetBeans 7.2.1 with JavaDB and when I'm trying to run a SQL query, such as:

SELECT * FROM mydatabase ORDER BY colname DESC LIMIT 0,1

and try to execute the commend, the console displays an error, namely:

Error code -1, SQL state 42X01: Syntax error: Encountered "limit" at line 1, column 55.

Any ideas on what I can do? Do you see something wrong with my query code?

Solution

  • Please consult the Derby FAQ at http://db.apache.org/derby/faq.html#limit