Maybe you should use @version Il giorno venerdì 25 novembre 2016 14:54:53 UTC+1, Aceitunas y encurtidos Quijote ha scritto: > > 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.