Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER @@
- CREATE PROCEDURE getPercentage
- (IN Enr_no INT, OUT Percentage INT)
- BEGIN
- SELECT ((Subject1+Subject2+Subject3)/3) INTO Percentage
- FROM result
- WHERE Enr_no=Enr_no;
- END @@
- DELIMITER ;
Add Comment
Please, Sign In to add comment