select top syntax

when i try to limit the out put of a query i use SELECT TOP 10 *
this gives me a syntax error in base using embedded hsqldb 1.8
is this not allowed? hsql doc lists it as valid

When running this command, turn on (toolbar SQL button) Run SQL command directly.

If this answers your question please click on the :heavy_check_mark: (upper left area of answer).