forum.lissyara.su

Код: Выделить всё

mysql> SELECT * FROM `WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
+---------+------------+-------+-----------+---------+--------+---------+--------+
| ID      | ContractID | Month | ServiceID | Comment | Cost   | Discont | Amount |
+---------+------------+-------+-----------+---------+--------+---------+--------+
| 8843074 |      10369 |   497 |     10000 | ?20440  |   1.67 |    0.10 |    365 |
| 8843077 |      10369 |   497 |     20000 | ?20441  | 150.00 |    1.00 |      1 |
+---------+------------+-------+-----------+---------+--------+---------+--------+
2 rows in set (0.92 sec)

mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)*100)/100 as `Summ` FROM `WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497); 
+------------+
| Summ       |
+------------+
| 548.594985 |
+------------+
1 row in set (0.91 sec)

mysql> SELECT 365 * 1.67 * ( 1 - 0.10);
+--------------------------+
| 365 * 1.67 * ( 1 - 0.10) |
+--------------------------+
|                 548.5950 |
+--------------------------+
1 row in set (0.00 sec)

mysql> 

Код: Выделить всё

SUM(`Amount`*`Cost`*(1-`Discont`))

Код: Выделить всё

mysql> SELECT `Amount`*`Cost`*(1-`Discont`) as `Summ` FROM `WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
+--------+
| Summ   |
+--------+
| 548.59 |
|   0.00 |
+--------+
2 rows in set (0.97 sec)

mysql>