15.02.2013 14:43, Johan De Meersman пишет:
- Original Message -
From: "Alex Keda"
mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EX
15.02.2013 15:07, Alex Keda пишет:
OK. But, how about:
mysql> SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
mysql>
??
sorry, I'
bkp0# mysql h5000_bill
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1643184
Server version: 5.1.68-log FreeBSD port: mysql-server-5.1.68
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracl
