欢迎来到牛牛题库网 牛牛题库官网
logo

单项选择题

在学生选课数据库中,查询平均成绩大于等于60分的同学,SQL语句为(       )
A、SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=60;
B、SELECT Sno FROM SC WHERE Grade>=60 GROUP BY Sno;
C、SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG(Grade)>=60;
D、SELECT Sno FROM SC GROUP BY Sno HAVING Grade >=60;

点击查看答案&解析
微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题