I've tried this but it does not work either. SELECT FROM CompositionVersions LET $temp = (select max(version) from CompositionVersions) WHERE $temp = version
El viernes, 25 de noviembre de 2016, 9:48:53 (UTC+1), Aceitunas y encurtidos Quijote escribió: > > Hi, I want to retrieve the latest version of each Composition object. > > *select from CompositionVersions where version = (select max(version) from > CompositionVersions)* > > But this not working. > > 1-Is there another more efficient way to recover the latest version, > without knowing the number of versions that there are? > 2-Would it be convenient to save in the Composition object, an attribute > with the id of the latest version? > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.