[ dsivic @ 05.04.2015. 19:46 ] @
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 | +----+---------+----------+ |