使用存储过程查询

Question

需求说明：
1.查询输出指定学期总课时和开设的课程名称，每门课程的课时
2.如果没有制定学期名称则查看每个学期的总棵时和开设的课程名称===提示===
为输入参数----课程名称指定默认值为null
判断输入参数是否为null
使用union关键字合并两个查询的记录select GradeName '年级名称',SubjectName '课程名称',sum(ClassHour) '总课时' from Grade
 inner join Subject j on j.GradeId=Grade.GradeId
where GradeName='S2'
group by GradeName,SubjectName,ClassHour
order by ClassHour desc结果如下年级名称                                               课程名称                                               总课时
-------------------------------------------------- -------------------------------------------------- -----------
S2                                                                                                    178
S2                                                 Project                                            42
S2                                                 Three Tier                                         28
S2                                                 JSP                                                26
S2                                                 C# OOP                                             24
S2                                                 JavaScript                                         24
S2                                                 T-SQL                                              22
S2                                                 Java OOP                                           12

Answer 1

怎么显示成这样了 我需要横排3列