the querry is to select sum( a*b) group by a ( a-1 ) (a,b columns) from a temp table which is created from the joins of other tables . can u suggest some thing on this ? is it possible using proj / hql ? how ?
On Nov 2, 11:23 pm, Fabio Maulo <[email protected]> wrote: > it can be done as you can do in SQL. > The question is why that function should be solved by RDBMS and not by BL or > Domain. > > 2009/11/2 n hibernate user <[email protected]> > > > > > How can we multiply / divide two columns of a table and take the sum > > of all these products using n hibernate ? suppose there r two columns > > ( A and B ) which are multiplied column wise and then summed across > > all the rows ? how can this be done using projections / h query ?? > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
