Code:
-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`broj_komada` smallint(4) DEFAULT '0',
`vrijeme_izrade` decimal(10,5) NOT NULL DEFAULT '0.00000',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of test3
-- ----------------------------
INSERT INTO `test` VALUES ('1', '19', '1.03298');
INSERT INTO `test` VALUES ('2', '19', '0.79643');
SELECT
SUM(broj_komada) AS bk,
SUM(vrijeme_izrade) AS viz,
SUM(broj_komada * vrijeme_izrade) AS ukupno
FROM
test
+----+---------+----------+
| bk | viz | ukupno |
+----+---------+----------+
| 38 | 1.82941 | 34.75879 |
+----+---------+----------+
SELECT
SUM(broj_komada) AS bk,
SUM(vrijeme_izrade) AS viz,
SUM(broj_komada) * SUM(vrijeme_izrade) AS ukupno
FROM
test;
+----+---------+----------+
| bk | viz | ukupno |
+----+---------+----------+
| 38 | 1.82941 | 69.51758 |
+----+---------+----------+
-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`broj_komada` smallint(4) DEFAULT '0',
`vrijeme_izrade` decimal(10,5) NOT NULL DEFAULT '0.00000',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of test3
-- ----------------------------
INSERT INTO `test` VALUES ('1', '19', '1.03298');
INSERT INTO `test` VALUES ('2', '19', '0.79643');
SELECT
SUM(broj_komada) AS bk,
SUM(vrijeme_izrade) AS viz,
SUM(broj_komada * vrijeme_izrade) AS ukupno
FROM
test
+----+---------+----------+
| bk | viz | ukupno |
+----+---------+----------+
| 38 | 1.82941 | 34.75879 |
+----+---------+----------+
SELECT
SUM(broj_komada) AS bk,
SUM(vrijeme_izrade) AS viz,
SUM(broj_komada) * SUM(vrijeme_izrade) AS ukupno
FROM
test;
+----+---------+----------+
| bk | viz | ukupno |
+----+---------+----------+
| 38 | 1.82941 | 69.51758 |
+----+---------+----------+