面试题,有三张表,学生表S,课程表C,学生课程表SC,学生可以选修多门课程,一门课程可能被多个学生选修,通过SC表关联。(1)写出建表以及插入语句;(2)写出SQL语句,查询选修了所有选修课程的学生;(3)写出SQL语句,查询选修了至少2门
posted @ 2016-04-17 23:04 guanzhenqiang 阅读(9036) 评论(1) 推荐(0)
posted @ 2016-04-17 23:04 guanzhenqiang 阅读(9036) 评论(1) 推荐(0)
posted @ 2016-04-17 22:00 guanzhenqiang 阅读(181) 评论(0) 推荐(0)
posted @ 2016-04-17 21:59 guanzhenqiang 阅读(638) 评论(0) 推荐(0)
posted @ 2015-12-13 22:40 guanzhenqiang 阅读(109) 评论(0) 推荐(0)
posted @ 2015-12-13 22:39 guanzhenqiang 阅读(129) 评论(0) 推荐(0)
posted @ 2015-12-13 22:38 guanzhenqiang 阅读(125) 评论(0) 推荐(0)
posted @ 2015-12-13 22:37 guanzhenqiang 阅读(140) 评论(0) 推荐(0)
posted @ 2015-12-13 22:35 guanzhenqiang 阅读(179) 评论(0) 推荐(0)