#EANF#

#EANF#

Firstly, I'm new to SQL - not so new to Java anymore.
Secondly, I'm using NetBeans 7.2.1 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?
THANKS! Johan