Hi Nicolas,
You can try the following query:
SELECT @rid as student, out("has") as mark from (
SELECT FROM Student ORDER BY avg_mark DESC LIMIT 3
) UNWIND mark
Thanks
Luigi
2017-04-13 14:15 GMT+02:00 nicolas treiber <[email protected]>:
> Hi.
> I'm pretty sure that what i want to do is not possible but maybe someone
> has a workaround (or it may give ideas to implement in future versions).
> Imagine you have a class Student with their average mark, and a class
> Mark. Every student a multiple marks.
> What I would like to do is get the three best students with their marks.
> I thought of something like: SELECT FROM (MATCH {class: Student, as:
> s}-has->{class: Mark, as: m}) ORDER BY s.avg_mark LIMIT 3
> But of course it only returns 3 results (so for example if all students
> has 10 marks, i would only get that first student with 3 marks instead of 3
> students with 10 marks each).
> Any idea ?
>
> --
>
> ---
> 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.
>
--
---
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.
