Hi all,
I tried to execute below query then it is returning error saying
that "Subquery is not a single column query; SQL statement:
<http://10.135.116.190:8082/query.do?jsessionid=1379985327b8d05d6dcbf34f041d1a54#>".
but it is working on other databases like DB2, Datacom etc...I have googled
the issue some of the folks are saying this feature not supported by H2 and
Derby. Can any body suggest me the solution or work around for this.
* My Query: *
SELECT * FROM REPORTINFO WHERE (REPORTINFOID , VERSION ) IN (SELECT
REPORTINFOID , MAX(VERSION ) AS VERSION FROM REPORTINFO WHERE DELETED
=FALSE GROUP BY REPORTINFOID )
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
