Its a bit tricky – the sum() function takes the start and adds it to the next and so on You need to implement the __radd__ method: class T: def __init__(self,x): self.x = x def __radd__(self, other): return other + self.x test = (T(1),T(2),T(3),200) print sum(test)
Select SUM(CASE When CPayment=”Cash” Then CAmount Else 0 End ) as CashPaymentAmount, SUM(CASE When CPayment=”Check” Then CAmount Else 0 End ) as CheckPaymentAmount from TableOrderPayment Where ( CPayment=”Cash” Or CPayment=”Check” ) AND CDate<=SYSDATETIME() and CStatus=”Active”;
This will do the trick: LINQ Query Syntax: from p in m.Items group p by 1 into g select new { SumTotal = g.Sum(x => x.Total), SumDone = g.Sum(x => x.Done) }; LINQ Method Syntax: m.Items .GroupBy(r => 1) .Select(g => new { SumTotal = g.Sum(x => x.Total), SumDone = g.Sum(x => x.Done) }); Notice … Read more
It’s best if you used an alias for your SUM: SELECT SUM(`field`) as `sum` FROM `table_name` And then, you’ll be able to fetch the result normally by accessing the first result row’s $row[‘sum’].
You can extend your strategy to an arbitrary number of sub-regions, and reduce them recursively, using tasks: #include<vector> #include<iostream> using namespace std; const int n = 10000; const int baseLength = 100; int f(int ii) { return ii; } int recursiveSumBody(int * begin, int * end){ size_t length = end – begin; size_t mid = … Read more
In case you want the sample to follow a uniform distribution, the problem reduces to generate N random numbers with sum = 1. This, in turn, is a special case of the Dirichlet distribution but can also be computed more easily using the Exponential distribution. Here is how: Take a uniform sample v1 … vN … Read more
You cannot expect any records to be outputted when using a GROUP BY clause, when no records exist in your source. If you want an output of 0 from the SUM and COUNT functions, then you should not use GROUP BY. The reason is that when you have no records, the GROUP BY clause has … Read more
Use COALESCE to avoid that outcome. SELECT COALESCE(SUM(column),0) FROM table WHERE … To see it in action, please see this sql fiddle: http://www.sqlfiddle.com/#!2/d1542/3/0 More Information: Given three tables (one with all numbers, one with all nulls, and one with a mixture): SQL Fiddle MySQL 5.5.32 Schema Setup: CREATE TABLE foo ( id INT NOT NULL … Read more
Use function array_reduce() to combine the items having the same city: $input = array( array(‘city’ => ‘NewYork’, ‘cash’ => ‘1000’), array(‘city’ => ‘Philadelphia’, ‘cash’ => ‘2300’), array(‘city’ => ‘NewYork’, ‘cash’ => ‘2000’), ); $output = array_reduce( // Process the input list $input, // Add each $item from $input to $carry (partial results) function (array $carry, … Read more
There is no need for a loop at all. You can use the triangular number formula: n = int(input()) print(n * (n + 1) // 2) A note about the division (//) (in Python 3): As you might know, there are two types of division operators in Python. In short, / will give a float … Read more