Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP PROCEDURE IF EXISTS odlicni;
- DELIMITER //
- CREATE PROCEDURE odlicni(IN kolegij VARCHAR(13))
- BEGIN
- DECLARE broj INT;
- SELECT COUNT(ocjene.ocjena) INTO broj FROM kolegiji
- JOIN ocjene ON kolegiji.id = ocjene.idKolegij
- JOIN studenti ON ocjene.jmbagStudent = studenti.jmbag
- WHERE ocjene.ocjena = 5 AND kolegiji.naziv = kolegij AND YEAR(studenti.datumUpisa) IN (YEAR(CURDATE())-1,YEAR(CURDATE())-2,YEAR(CURDATE())-3);
- UPDATE kolegiji
- SET `odlicniStudenti` = broj
- WHERE naziv = kolegij;
- END; //
- DELIMITER ;
- SET @a='Fizika';
- CALL odlicni(@a);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement