Guest User

Untitled

a guest
Jan 21st, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. DELIMITER @@
  2. CREATE PROCEDURE getPercentage
  3. (IN Enr_no INT, OUT Percentage INT)
  4. BEGIN
  5. SELECT ((Subject1+Subject2+Subject3)/3) INTO Percentage
  6. FROM result
  7. WHERE Enr_no=Enr_no;
  8. END @@
  9. DELIMITER ;
Add Comment
Please, Sign In to add comment