please try with select value.uid.value as id, value.context.start_time.value as date from CompositionVersions order by date desc limit 5
Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > I have tried with this query and I get this results (not ordered): > > *select value.uid.value as id, value.context.start_time.value as date* > *from CompositionVersions order by value.context.start_time.value desc > limit 5* > > id > date > fe9e6036 > 2014-02-23T12:33:10.000+01:00 > 80eee423 > 2014-03-08T11:35:25.000+01:00 > 0600c7bd > 2014-01-27T22:49:36.000+01:00 > 291c1e1e > 2014-03-08T04:28:15.000+01:00 > a8b7d7c9 > 2014-01-04T03:31:02.000+01:00 > > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
