tabela izgleda ovako:
Code:
id_isp|dm_nalog|sifra_radnika|kolicina|ocena_positive|ocena_negative|isporuka|karton|datum
391 1327 27 1 150 0 14 2 2007-09-05
413 1396 27 1 150 0 14 6 2007-09-07
449 916 27 1 150 0 14 11 2007-08-31
503 1407 27 1 120 0 15 13 2007-09-18
513 1414 27 1 120 0 15 14 2007-09-19
517 1452 27 1 120 0 15 14 2007-09-19
531 1430 27 1 150 0 15 16 2007-09-19
556 1312 27 1 0 120 15 20 2007-09-20
558 1321 27 3 0 270 15 20 2007-09-20
585 1488 27 1 150 0 15 26 2007-09-21
id_isp|dm_nalog|sifra_radnika|kolicina|ocena_positive|ocena_negative|isporuka|karton|datum
391 1327 27 1 150 0 14 2 2007-09-05
413 1396 27 1 150 0 14 6 2007-09-07
449 916 27 1 150 0 14 11 2007-08-31
503 1407 27 1 120 0 15 13 2007-09-18
513 1414 27 1 120 0 15 14 2007-09-19
517 1452 27 1 120 0 15 14 2007-09-19
531 1430 27 1 150 0 15 16 2007-09-19
556 1312 27 1 0 120 15 20 2007-09-20
558 1321 27 3 0 270 15 20 2007-09-20
585 1488 27 1 150 0 15 26 2007-09-21
upit koji sam pisao koji treba da mi sabere ocena_poztiv za datum od do i sifru radniku recimo 27:
Code:
SELECT sum( ocena_positive )
FROM isporuka
WHERE sifra_radnika = '27'
AND datum
BETWEEN '20070901'
AND '20070930'
SELECT sum( ocena_positive )
FROM isporuka
WHERE sifra_radnika = '27'
AND datum
BETWEEN '20070901'
AND '20070930'
meni taj upit vrati: 960
a prostom racunicom vidim da treba da bude 1110
sta sam pogresio? datum od do? potreban je neki group by??
pomagajte.. nista mi nije jasno