create procedure xxk2
as
begin
select x.学号,x.姓名,x.专业,count(*) as 门数
from students x,score y
where x.学号=y.学号
group by x.学号,x.姓名,x.专业
end
显示出AAA库中每个学生的学号、姓名、专业等信息及选课门数
。
create procedure xxk2
as
begin
select x.学号,x.姓名,x.专业,count(*) as 门数
from students x,score y
where x.学号=y.学号
group by x.学号,x.姓名,x.专业
end
显示出AAA库中每个学生的学号、姓名、专业等信息及选课门数
。
