下列SELECT语句语法正确的是()。A)SELECT木FROM‘teacher' WHERE性别=‘男’B)SELECT宰FR
下列SELECT语句语法正确的是()。
A)SELECT木FROM‘teacher' WHERE性别=‘男’
B)SELECT宰FROM‘teacher’WHERE性别=男
C)SELECT木FROM teacher WHERE性别=男
D)SELECT木FROM teacher WHERE性别=‘男’
下列SELECT语句语法正确的是()。
A)SELECT木FROM‘teacher' WHERE性别=‘男’
B)SELECT宰FROM‘teacher’WHERE性别=男
C)SELECT木FROM teacher WHERE性别=男
D)SELECT木FROM teacher WHERE性别=‘男’
A、select (name) from table person: 所有记录的name字段的值
B、select (name) from person where age=12 or name=’aa‘; or 或者
C、select (name) from table person where age=12; 查找age=12的记录的那个字段的值
D、select (name,age) from person where age=12 and name=‘aa’; and 并且
A、SELECT * FROM '学生表’WHERE 性别='男’
B、SELECT * FROM '学生表’WHERE 性别=男
C、SELECT * FROM 学生表 WHERE 性别=男
D、SELECT * FROM 学生表 WHERE 性别=‘男‘
A. DECLARE @Myvar INT
B. SELECT * FROM [AAA]
C. CREATE DATABASE AAA
D. DELETE * FROM AAA
A、Exec proc_score
B、Exec proc_score 60,90
C、Exec proc_score @passed=65,@ecellent=95
D、Exec proc_score @passed=65,90
查询没学过"张三"老师讲授的任一门课程的学生姓名 solution1 select * from student where student.SId not in ( select student.SId from ( select student.SId, t.CId from ( select course.CId from course, teacher where course.TId = teacher.TId and teacher.Tname = '张三') as t, student) as t1 right join sc on t1.SId=sc.SId and t1.CId=sc.CId, student where t1.SId=student.SId) solution2 select * from student where student.SId not in (select student.SId from student left join sc on student.SId=sc.SId where EXISTS (select * from teacher ,course where teacher.Tname='张三' and teacher.TId=course.TId and course.CId=sc.CId))
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!