Hi Munish,

SQL predicates semantic doesn't imply order.

Have you tried following?
select from [#1:87, #1:10, #1:11]



Best regards,
Artem Orobets

* Orient Technologiesthe Company behind OrientDB*


2014-06-04 0:30 GMT+03:00 Munish Chopra <[email protected]>:

> Hi Luca,
>
> My goal is to fetch multiple records in a particular order and I have
> their @rids.
>
> E.g :- Let say I have a user table
>
> If I do,
> select from user where @rid = 1:87 or @rid = 1:10 or @rid = 11
>
> the result will be automatically ordered as per @rid . result will be
> @rid         name
> 1:10            B
> 1:11            HH
> 1:87            hhh
>
> Is there a way I can get the result in the same manner I am entering the
> ids? i.e the result should be
> 1:87
> 1:10
> 1:11
>
>
> Regards,
> Munish
>
> --
>
> ---
> 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.

Reply via email to