Have you tried concatenating the two columns into one column? I don't know if that would work, just an idea.
PS: I think you'd have more success finding a solution if you post this on stackoverflow.com On Wednesday, 5 October 2016 09:14:06 UTC+2, Ramesh Elkaturi wrote: > > 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.
