Posts by Brenno Rovea • 23 points
3 posts
-
0
votes2
answers97
viewsQ: Chaining - R
I have two dates frames, one containing product data and the other containing store data, however I do not have reference variables between them (which would not allow me an Inner Join), my need is…
rasked Brenno Rovea 23 -
0
votes1
answer436
viewsQ: Sum a summed field - PL/SQL
I need to make the sum of a field to which a sum was made as the example below: SELECT A.*, B.* FROM (SELECT DTAGENDA, AG.CODITPROD, CD, ROW_NUMBER() OVER(PARTITION BY AG.CODITPROD, CD ORDER BY…
-
1
votes1
answer41
viewsQ: How to realize the sum of values I multiplied?
I performed an operation that multiplies the amount of values by the unit value of each one, obtaining the total value per product. How could I add up the total values of all products? I tried with…
sqlasked Brenno Rovea 23