B.NAME= ‘%张%’
C.NAME LIKE ‘张%’
D.NAME LIKE ‘张*’
B.NAME= ‘%张%’
C.NAME LIKE ‘张%’
D.NAME LIKE ‘张*’
A、update students set Grade=Grade+10 where SID=1
B、update * set Grade=Grade+10
C、update * from stedents set Grade=Grade+10
D、update students set Grade=Grade+10
A、9,9
B、9,10
C、10,10
D、10,9
A、select * into stufemal from student
B、select * into stufemal from student where ssex='女'
C、select * from student where ssex='女' into stufemal
D、select * from student into stufemal
查询没有学全所有课程的同学的信息 这种解法不包括什么课都没选的学生 select student.* from student, (select sid, count(cid) as coursecount from sc group by sid) as t1 where student.sid = t1.sid and t1.coursecount<>3 select student.* from sc ,student where sc.SId=student.SId GROUP BY sc.SId Having count(*)<(select count(*) from course) 利用笛卡尔积可以把什么课都没选的同学查询出来 select distinct student.* (select student.sid,course.cid student,course ) as t1 left join sc.sid,sc.cid sc)as t2 on t1.sid="t2.SId" and t1.cid="t2.CId,student" where t2.sid is null student student.sid not in ( sc, sc.sid="student.sid" group by sid having>
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!