首页SELECT cName,score FROM course,sc WHERE sc.cNo = course.cNo AND sNo = (SELECT sNo FROM student WHERE sName = '王兵');

SELECT cName,score FROM course,sc WHERE sc.cNo = course.cNo AND sNo = (SELECT sNo FROM student WHERE sName = '王兵');

时间: 2024-06-10 22:06:19 浏览: 207

学生课程成绩查询系统（C语言）

学生课程成绩查询系统，C语言编写，大一大二均适用，内含12个功能，功能齐全

您想查询学生王兵所选的课程名和分数，正确的SQL语句应该是： SELECT cName, score FROM course, sc WHERE sc.cNo = course.cNo AND sc.sNo = (SELECT sNo FROM student WHERE sName = '王兵');

SELECT cName,score FROM course,sc WHERE sc.cNo = course.cNo AND sNo = (SELECT sNo FROM student WHERE sName = '王兵');

相关推荐

数据库系统概论Sql练习表student、sc、course.pdf

USE teaching SELECT A.sno, sname, C.cno, cname, score FROM student A ,sc B , course C where B.cno=C.cno and A.sno=B.sno AND score>=90 该程序的功能是：

delete from sc from sc join student on sc.sno=student.sno from sc join course on sc.cno=course.cno where student.sdept ='计算机系'and grade <60 and cnamne='java'对不对

CREATE VIEW V_SCG AS SELECT Sno,Sname,Cname,Score,Credit from student,grade,course WHERE grade.Sno = student.Sno AND grade.Cno = course.Cno AND Cno = '0001'; 哪里错了

CREATE PROCEDURE s_grade @sno char(20) AS BEGIN SELECT student.sno, student.sname, course.cname, sc.grade FROM student INNER JOIN sc ON student.sno = sc.sno INNER JOIN course ON sc.cno = course.cno END

41 使用jxgl数据库，查询没有被选修过的课程的课程号和课程名。 select cno,cname from Course join sc on Course.cno=sc.cno where Course.cno = Null;

UPDATE SC SET Grade=Grade+1 WHERE Cno IN( SELECT Course.Cno FROM Course,SC WHERE SC.Cno = Course.Cno and Cname = '数据库' ); 实现为什么不对呢

create view view136 (sno36，sname36，cname36，grade36) as select sc36.sno36，sname36，cname36，grade36 from student36,course36,sc36 where student36.sno36=sc36.sno36 and course36.cno36=sc36.cno36;有错误吗

CREATE PROCEDURE Proc_Selesno ( VARIABLE student_id INT ) BEGIN SELECT s.*, c.Cname, sc.grade FROM S s INNER JOIN SC sc ON s.sno = sc.sno INNER JOIN C c ON sc.cno = c.cno WHERE s.sno = student_id; END

CREATE VIEW scs_view_8208210915 AS SELECT s.Sno, s.Sname, c.Cno, c.Cname, r.Score FROM Students_8208210915 s, Courses_8208210915 c, Score_8208210915 r WHERE s.Sno = r.Sno AND c.Cno = r.Cno;

select sc.sno,sname from sc join students on sc.sno=students.sno where cno in (select cno from course where cname='操作系统' and '数据结构与算法');

SELECT s.sdept, c.cname, AVG(sc.grade) AS 平均成绩 FROM S s, SC sc WHERE s.sno = sc.cno GROUP BY s .sdept, c.cname

SELECT stu.sid,stu.sname, c.cname, sc.score FROM student stu, course c, sc WHERE sc.score < 60 AND c.cname = "python" GROUP BY c.cname;检查语法

select sno,sname from sc where cno in (select cno from Course where cname='数据库原理' and '数据结构')

最新推荐

STM32F103单片机连接A7680C-4G模块，并支持手机连接WIFI配置修改4G模块远程TCP的目标IP和端口.zip

Elasticsearch核心改进：实现Translog与索引线程分离

管理建模和仿真的文件

病房呼叫系统设计基础：7个关键架构策略让你一步入门

Selenium如何获取Shadow DOM下的元素属性？

分享个人Vim与Git配置文件管理经验

"互动学习：行动中的多样性与论文攻读经历"

【Genesis 2000教程】：7个技巧助你精通界面布局与操作

求出所有100到200以内的偶数，并放在数组中，按照每行5个输出

文本动画新体验：textillate插件功能介绍