sql面试题详解

select a.sno,a.sname,avg(b.score) from student a left JOIN sc b on a.sno = b.sno GROUP BY a.sno having avg(score)>60

2015-08-07 16:53:06

阅读数 331

评论数 0

提示
确定要删除当前文章?
取消 删除
关闭
关闭