Try with:
SELECT @rid, $edge_count FROM VertexType LET $edge_count =
in('EdgeType').size() ORDER BY $edge_count DESC LIMIT 20
Lvc@
ᐧ
On 25 August 2014 19:47, <[email protected]> wrote:
> Hi,
>
> This works beautifully but the @rid comes out wrong and looks like a
> temporary #-2:282
> <http://localhost:2480/studio/index.html#/database/mobilitus/browse/edit/-2:282>
> rid.
>
> Any ideas?
>
> Regards,
> -Stefán
>
>
> On Monday, 25 August 2014 17:35:48 UTC, Lvc@ wrote:
>
>> Hi Stefan, try something like:
>>
>> SELECT FROM VertexType LET $edge_count = in('EdgeType').size() ORDER BY
>> $edge_count DESC LIMIT 20
>>
>> Lvc@
>> ᐧ
>>
>>
>> On 25 August 2014 19:28, <[email protected]> wrote:
>>
>>> Hi,
>>>
>>> How can I select vertexes with the highest number of outgoing edges of a
>>> particular type?
>>>
>>> something like the following comes to mind but does not work:
>>>
>>> select count(in_EdgeType) as edge_count from VertexType order by
>>> edge_count desc limit by 20
>>>
>>>
>>> Regards,
>>> -Stefán
>>>
>>>
>>> --
>>>
>>> ---
>>> 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.
>
--
---
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.
