查询没有选修java的学生_查询没有选修数据库课程的学生的学号

2018-05-04

求sql大神速度告诉我吧~~~~真的很急啊~~

1 select * from TBL_STU order by Birth ASC2 select * from TBL_STU where SEX='女'2 select count(*) from TBL_STU where SEX='女'3 select name,Elective,Results from TLB_Stu where 选课条件，//不知道字段，不好写4 select name from TBL_Stu where Results2010 select name,age from TBL_STU where Birthplace='河北' and sex='男'1...全部

1 select * from TBL_STU order by Birth ASC2 select * from TBL_STU where SEX='女'2 select count(*) from TBL_STU where SEX='女'3 select name,Elective,Results from TLB_Stu where 选课条件，//不知道字段，不好写4 select name from TBL_Stu where Results2010 select name,age from TBL_STU where Birthplace='河北' and sex='男'11 select name,sex from TBL_STU where Birthplace is null12 select name from TBL_STU where Results=9513 select CoursesName from Courses where ClassTime='45'。

。。写的头痛了，你应该把表结构写出来的，，，上面表越来越多，我都不好猜了。收起