CREATE PROCEDURE dbname.proc_getGrade
(stu_no varchar(20),cour_no varchar(10))
BEGIN
DECLARE stu_grade float;
SELECT grade into stu_grade FROM grade
WHERE student_no=stu_no AND course_no=cour_no;
IF stu_grade>=90 THEN
SELECT stu_grade,'A';
ELSEIF stu_grade<90 AND stu_grade>=80 THEN
SELECT stu_grade,'B';
ELSEIF stu_grade<80 AND stu_grade>=70 THEN
SELECT stu_grade,'C';
ELSEIF stu_grade70 AND stu_grade>=60 THEN
SELECT stu_grade,'D';
ELSE
SELECT stu_grade,'E';
END IF;
END
if else 语句规范
最新推荐文章于 2023-04-08 01:15:08 发布