Hi, As Nagu reported, using LET allows to do that. Lvc@
Best Regards, Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB http://about.me/luca.garulli On 29 April 2015 at 08:28, Krishna Kumar <[email protected]> wrote: > i am working orientdb document database.........its showing invalid > keyword select inside sum functions > > On Tuesday, April 28, 2015 at 3:08:25 PM UTC+5:30, Krishna Kumar wrote: > >> HI, >> >> is it possible to apply math functions over projections? >> >> *example : *select sum((select count(*) from Regressionresults where >> ComponentName = 'FirstPageConfig' and testResult = 'passed' ,(select >> count(*) from Regressionresults where ComponentName = 'FirstPageConfig')) >> from Regressionresults >> >> >> its showing some exceptions like unknown keyword "SELECT" ........if >> possible give me some related working queries >> > -- > > --- > 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.
