How can i except like in sql with OrientDb

[Messaoud Mohamed]

Hello 

how can i make use somthink like except  with orientdb graph 

i have this two query i want to use with:

1)select * from User 

2)select expand(distinct(@rid)) from (select expand(both('follow')) from user WHERE @rid=12:2)

the result must be all the nodes from query 1 except the result of the second query 

Thank you 

[user.w...@gmail.com]

Hi, 

try this:

select * from User where @rid not in (select expand(distinct(@rid)) from (select expand(both('follow')) from user WHERE @rid=12:2))

Hope it helps,

Regards

Michela

[Messaoud Mohamed]

it help Thank you so much 😁

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/8EmzZqW_8sE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.