Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
JDBC and Relational Databases
how to - correlated subquery in HSQLDB
posted 2 years ago
Don't know whether I'm in the right place but here goes.
I am trying to use Libreoffice Base - Which., I understand, uses HSQLDB.
I'm trying to input a correlated subquery as so: ( I split the actual command here for clarity, appears as one line on command line)
SELECT player, playdate, score FROM bdata AS t WHERE playdate IN ('2015-01-05', '2015-01-19') AND ( SELECT COUNT(*) FROM bdata WHERE playdate = t.playdate AND score > t.score ) <6 ORDER BY playdate, score DESC;
I keep getting syntax errors: SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
Any idea how to fix this would be appreciated.
Boost this thread!
The system cannot find the path specified
Querying A DB2 Table Last Update Date
Correlated subqueries in HQL Select Clause
retrieve data from huge result set
ERROR 1016 (HY000): Can't open file: 'TABLE_NAME.InnoDB' (errno: 1) - MySQL