Hi,
try this query and let me know
select @rid, count(*) as NumberOfMutualFriends from
( select expand($friends.out('isFriendsWith')) from #11:5
let $friends = out('isFriendsWith'))
where @rid <> "11:5" AND (rid NOT IN $friends)
group by @rid
order by NumberOfMutualFriends desc
Alessandro
--
---
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.
