Have a look at timestampdiff which doesn’t have the TIME limitation. I.e. something like (untested): SELECT CONCAT( TIMESTAMPDIFF(HOURS, entry_end_time, entry_start_time), “:”, MOD(TIMESTAMPDIFF(MINUTES, entry_end_time, entry_start_time),60) ) AS total FROM entry WHERE entry_date BETWEEN ‘2012-01-01’ AND ‘2012-12-31′ AND user_id = 3 The concats not ideal, I’m sure there will be a more elegant solution.
As Sammaye indicated, you need to $unwind the Egresos array to duplicate the matched doc per array element so you can $sum over each element: db.Cuentas.aggregate([ {$match: {“Usuario”: “MarioCares”} }, {$unwind: ‘$Egresos’}, {$group: { _id: null, “suma”: {$sum: “$Egresos.Monto” } }} ])
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
You’d have to do this manually using a loop. Something like this should work: $result = array(); foreach( $input as $row) { $id = array_shift( $row); foreach( $row as $key => $value) { $result[ $id ][ $key ] = ( isset( $result[ $id ][ $key ]) ? $result[ $id ][ $key ] + $value : … 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
You can use reduce for that, below function takes as many objects as you want and sums them by key: var obj1 = { a: 12, b: 8, c: 17 }; var obj2 = { a: 12, b: 8, c: 17 }; var obj3 = { a: 12, b: 8, c: 17 }; function sumObjectsByKey(…objs) … Read more
Well the problem simply-put is that the SUM(TIME) for a specific SSN on your query is a single value, so it’s objecting to MAX as it makes no sense (The maximum of a single value is meaningless). Not sure what SQL database server you’re using but I suspect you want a query more like this … Read more
Two ways: Use indexes: double sum = 0; for(int i = 0; i < m.size(); i++) sum += m.get(i); return sum; Use the “for each” style: double sum = 0; for(Double d : m) sum += d; return sum;
$sums = array(); foreach (array_keys($a1 + $a2) as $key) { $sums[$key] = (isset($a1[$key]) ? $a1[$key] : 0) + (isset($a2[$key]) ? $a2[$key] : 0); } You could shorten this to the following using the error suppression operator, but it should be considered ugly: $sums = array(); foreach (array_keys($a1 + $a2) as $key) { $sums[$key] = @($a1[$key] … Read more