Hi Hung Tran, I would advise you to use your first 'Working SQL' in this case but if you want to use the LET statement in your queries this could be a solution:
select Name, $v1.max from TestClass let $v1=(select max(IntF) from TestClass where $parent.current.Name in Name) group by Name Which gives the same results. could it be helpful ? -- --- 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.
