热门

最新

红包

立Flag

投票

同城

发布
weixin_52238867
Coreleon
3 年前
trueweixin_52238867

SELECT *
FROM student stu1
WHERE EXISTS
(SELECT College
FROM student
WHERE stu1.`College` = college AND NAME = '张三'
);

SELECT sno,score
FROM choose
WHERE courseid='C1' and
score<any(SELECT score
from choose,student
where student.sno=choose.sno and name='张三' and courseid='C1');

SELECT SNO
FROM choose
WHERE CourseID = 'C1'
UNION
SELECT SNO
FROM choose
WHERE CourseID = 'C3';
评论
1
打赏
  • 复制链接
  • 举报
下一条：
INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00002','C1 ','80');INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00002','C2 ','85');INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00003','C1 ','78');INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00003','C3 ','70');SELECT SNO,NAME FROM StudentWHERE College = '计算机学院';SELECT DISTINCT *FROM Student,course,chooseWHERE Age BETWEEN 20 AND 23;SELECT COUNT(DISTINCT SNO)FROM Student;SELECT MAX(Score)FROM ChooseWHERE CourseID = 'C1';SELECT MIN(Score)FROM ChooseWHERE CourseID = 'C1';SELECT SUM(Score)FROM ChooseWHERE CourseID = 'C1';SELECT AVG(Score)FROM ChooseWHERE CourseID = 'C1';SELECT CourseID,CourseNameFROM CourseWHERE CourseBeforeID IS NULL; SELECT Student.`SNO`,Student.`Name`,Course.`CourseName`,choose.`Score`FROM student,choose,courseWHERE choose.`SNO` = student.`SNO` AND course.`CourseID` = choose.`CourseID`;SELECT SNO,NAME,AgeFROM StudentWHERE College IN (SELECT College FROM Student WHERE NAME = '张三' );