语句 SELECT * FROM StInfo WHERE ClName = (SELECT ClName FROM StInfo WHERE StName='金萍') 是查询和金萍同班的同学的信息。
- · 有6位网友选择 对,占比60%
- · 有4位网友选择 错,占比40%
A、CNo='20190101' AND CNo='20190102'
B、CNo!='20190101' OR CNo # '20190102'
C、CNo<>'20190101' OR CNo!='20190102'
D、CNo!='20190101' AND CNo!='20190102'
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
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!