![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
小飞侠xi
IT菜鸟学习笔记
展开
-
Oracle sql语句
查询成绩在80~90之间的记录。SELECT Student.Sno,Sname,Dept,Course.Cno,ScoreFROM Student,SC,CourseWHERE Student.Sno=SC.Sno AND SC.Score BETWEEN 80 AND 90 AND SC.Cno=Course.Cno查询至少有4个同学选修的课程名。USE jia...原创 2019-09-25 18:07:17 · 1953 阅读 · 0 评论 -
Oracle sql语句
3-2usejxskinsertintoSC values('s3','c2','70')insertintoSC values('s3','c4','85')insertintoSC values('s4','c2','85')insertintoSC values('s4','c3','83')insertintoSC values('s5','c...原创 2019-09-26 09:42:00 · 1107 阅读 · 0 评论