写出SQL语句，查询出总成绩大于150的学生各科成绩
答案:2 悬赏:20
解决时间 2021-01-20 19:04
- 提问者网友：王者佥
- 2021-01-20 16:08
写出SQL语句，查询出总成绩大于150的学生各科成绩
最佳答案
- 二级知识专家网友：撞了怀
- 2021-01-20 16:17
SELECt * FROM XSCJWHERe[SNAME]IN (SELECt [SNAME] FROM
(SELECt [SNAME],SUM([SCJ]) AS [ZCJ] FROM XSCJ GROUP BY [SNAME]HAVINg SUM([SCJ]) >150) A )
(SELECt [SNAME],SUM([SCJ]) AS [ZCJ] FROM XSCJ GROUP BY [SNAME]HAVINg SUM([SCJ]) >150) A )
全部回答
- 1楼网友：冷風如刀
- 2021-01-20 17:29
select * from xscj where name in (select name from xscj group by name having sum(score) > 150)
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯