-- 示例: 输入两个工资范围,列出这个范围工资的员工是哪些
drop procedure if exists test;
delimiter $$
create procedure test( in min_sal int(5) , in max_sal int(5) )
begin
select ename , sal from emp where sal between min_sal and max_sal ;
end $$
call test( 10000 , 16000 );