存储过程练习

创建一个存储过程，以部门号为参数，查询该部门的平均工资，并输出中比平均工资高的其中一位员工的员工号。
表：department; deno emno salary

Connect to sample@
Create procedure d_pro (in dn int,out en int)
Language sql

Begin 
	Declare tempSalary int default 0;
	Declare c1 cursor for
Select avg(salary) from department where deno=dn;
Declare c2 cousor for Select en from department where salary > tempSalary;
	 Open c1;
	 Fetch from c1 into tempSalary;
	 Close c1;
	 Open c2;
	 Fetch from c2 into en;
	 Close c2;
end@