use stusys;
select * from score;
delimiter //
create procedure P_maxGrade(in v_sno char(10))
begin
select max(geade) from score
where sno=v_sno;
end//
delimiter ;
call P_maxGrade('196001');
use stusys;
select * from score;
delimiter //
create procedure P_maxGrade(in v_sno char(10))
begin
select max(geade) from score
where sno=v_sno;
end//
delimiter ;
call P_maxGrade('196001');