Q&A BY TAG 'JDBC Query limit'

I'm trying to execute the following query : SELECT * FROM (SELECT * FROM Connections LIMIT 1000) AS T LIMIT 1; But its giving the following error : Exception parsing query near 'LIMIT' . Can someone help ? OR suggest any alternative working way of ...

JDBC Query limit SQL

There is an issue with putting limits on the query through the JDBC version. using select * from <table> limit 200 does not work. It is like the JDBC doesn't parse the limit constraint to the VQL.

JDBC Query limit