你可能感兴趣的试题
SELECT * FROM s SELECT * FROM s WHERE sex=’女’ SELECT sname FROM s WHERE sex=’女’ SELECT * FROM s WHERE grade="
SELECT sname FROM student,SELECT cno,grade FROM sc WHERE studensno=ssno SELECT sname,cno,grade FROM student,course WHERE studensno=courscno SELECT sname,cname,grade FROM student,course,sc WHERE studensno=ssno and scno=course,cno SELECT sname,cno,grade FROM student,sc WHERE studensno=ssno
SELECT * FROM s SELECT * FROM s WHERE sex=‘女’ SELECT sname FROM s WHERE sex=‘女’ SELECT * FROM s WHERE grade=''
UPDATE SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩'WHERE sname='张明'
第(38)~(40)题基于学生一课程数据库中的3个基本表:
学生信息表:s(sno,sname,sex,age,dept)主码为sno
课程信息表:c(cno,cname,teacher)主码为cno
学生选课信息表:sc(sno,cno,grade)主码为(sno,cno)
SELECT FROM S SELECT FROM s WHERE sex=’女’ SELECT sname FROM S WHERE sex=’女’ SELECT FROM S WHERE grade=’’
学生信息表s中的主码可以改为 sname 如果知道了课程的cno,并不一定能够找到惟一的grade 如果知道了课程的cno就可以在c表巾找到惟一的课程名称 如果知道了学生的sname,并不一定能够找到惟一的sno
SELECT * FROM s SELECT * FROM s WHERE sex='女' SELECT sname FROM s WHERE sex='女' SELECT * FROM s WHERE grade="
SELECT * FROM s SELECT * FROM s WHERE sex='女' SELECT sname FROM s WHERE sex='女' SELECT * FROM s WHERE grade=''
SELECT* FROM s SELECT* FROM s WHERE sex:='女' SELECT sname.FROM s WHERE sex='女' SELECT*FROM s WHERE grade=/
SELECT * FROM s SELECT * FROM s WHERE sex='女' SELECT sname FROM s WHERE sex='女' SELECT * FROM s WHERE grade="
SELECT * FROM s SELECT * FROM s WHERE sex=‘女’ SELECT sname FROM s WHERE sex=‘女’ SELECT * FROM s WHERE grade=''
SELECT * FROM s SELECT * FROM s WHERE sex=’女’ SELECT sname FROM s WHERE sex=’女’ SELECT * FROM s WHERE grade="
SELECT * FROM s SELECT * FROM s WHERE sex='女' SELECT sname FROM s WHERE sex='女' SELECT * FROM s WHERE grade=''
SELECT * FROM s SELECT * FROM s WHERE sex='女' SELECT sname FROM s WHERE sex='女' SELECT * FROM s WHERE grade=''
UPDATE SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩'WHERE sname='张明' 第(38)~(40)题基于学生一课程数据库中的3个基本表: 学生信息表:s(sno,sname,sex,age,dep主码为sno 课程信息表:c(cno,cname,teache主码为cno 学生选课信息表:sc(sno,cno,grad主码为(sno,cn