对于表 score(sti_id,sname,math,English,VB)的操作,下列语句中正确的是()。
A、SELECT stu_id,sum(math) FROM score ORDER BY math
B、SELECT sum(math),avg(VB) FROM score
C、SELECT * , sum(english) FROM score GROUP BY *
D、DELETE * FROM score
A、SELECT stu_id,sum(math) FROM score ORDER BY math
B、SELECT sum(math),avg(VB) FROM score
C、SELECT * , sum(english) FROM score GROUP BY *
D、DELETE * FROM score
A、1
B、2
C、3
D、4
A、SELECT StName, ClName,YEAR(GETDATE())-YEAR(birthdate) age FROM StInfo WHERE age<18<br> B、SELECT StName, ClName, YEAR(GETDATE())-YEAR(birthdate) FROM StInfo WHERE YEAR(birthdate)<18<br> C、SELECT StName, ClName, YEAR(GETDATE())-YEAR(birthdate) age FROM StInfo WHERE YEAR(GETDATE())-YEAR(birthdate)<18<br> D、SELECT StName, ClName, YEAR(date())-YEAR(birthdate) FROM StInfo WHERE age<18<br>
A、SELECT * FROM SCInfo WHERE Score=NULL
B、SELECT * FROM SCInfo WHERE Score IS ''
C、SELECT * FROM SCInfo WHERE Score =''
D、SELECT * FROM SCInfo WHERE Score IS NULL
A、SELECT CName, TOP(Score) AS 分数 FROM CInfo, SCInfo WHERE CInfo.CNo= SCInfo.CNo GROUP BY CName
B、SELECT CName, MAX(分数) 分数 FROM CInfo, SCInfo WHERE CInfo.CNo = SCInfo.CNo GROUP BY CName
C、SELECT CName, TOP (分数) 分数 FROM CInfo, SCInfo WHERE CInfo.CNo = SCInfo.CNo GROUP BY CInfo.CName
D、SELECT CName,MAX(分数) AS 分数 FROM CInfo,SCInfo WHERE CInfo.CNo = SCInfo.CNo GROUP BY CInfo.CNo
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!