语法: create proc myproc as ... 范例 例1 从SC表中查询不及格课程超过3门的学生信息 create proc myproc as select* from student where Sno in ( select sno from SC where Grade < 60 group by Sno having COUNT(*) >