MYSQL ifelse语句
标签：mit oba declare lse rust har int lob UNC
MYSQL ifelse语句
"A";
IF salary<5000 THEN SET grade ="E";
ELSEIF salary<10000 THEN SET grade ="D";
ELSEIF salary<15000 THEN SET grade ="C";
ELSEIF salary<20000 THEN SET grade ="B";
ELSE SET grade="A";
END IF;
RETURN grade;
END $$
DELIMITER ;
SELECT pro_salary_grade(16000);