SQLyog
世昌愿世昌盛
脱离业务讲代码全是耍流氓
展开
-
查询不及格的课程
SELECT stu.s_name ,s.s_score,c.c_name FROM student stuJOIN score s ON stu.s_id =s.s_idJOIN course c ON s.c_id=c.c_idWHERE s.s_score<60原创 2020-10-06 07:53:04 · 10799 阅读 · 0 评论 -
查询任何一门课程成绩在70分以上的姓名、课程名称和分数
SELECT stu.s_name ,s.s_score,c.c_name FROM student stuJOIN score s ON stu.s_id =s.s_idJOIN course c ON s.c_id=c.c_idWHERE s.s_score>70原创 2020-10-06 07:52:31 · 14645 阅读 · 0 评论 -
查询所有学生的课程及分数情况;
SELECT stu.s_name ,s.s_score,c.c_name FROM student stuJOIN score s ON stu.s_id =s.s_idJOIN course c ON s.c_id=c.c_id原创 2020-10-06 07:51:59 · 11783 阅读 · 0 评论 -
查询课程名称为“数学“,且分数低于60的学生姓名和分数
查询课程名称为"数学",且分数低于60的学生姓名和分数SELECT stu.s_name ,s.s_score FROM student stuJOIN score s ON stu.s_id =s.s_idJOIN course c ON s.c_id=c.c_idWHERE c.c_name=“数学” AND s.s_score<60原创 2020-10-06 07:51:12 · 11448 阅读 · 0 评论 -
查询男生、女生人数
查询男生、女生人数SELECT COUNT(s_sex) FROM student GROUP BY s_sex原创 2020-10-06 07:50:35 · 14189 阅读 · 0 评论 -
查询出只有两门课程的全部学生的学号和姓名
查询出只有两门课程的全部学生的学号和姓名SELECT stu.* FROM score s,course c,student stu WHERE s.c_id=c.c_id AND stu.s_id=s.s_id GROUP BY s.s_id HAVING COUNT(*)=2原创 2020-10-06 07:50:14 · 11646 阅读 · 0 评论 -
查询至少有一门课与学号为“01“的同学所学相同的同学的信息
SELECT stu.* FROM course c,student stu,score s WHERE stu.s_id =s.s_id AND c.c_id=s.c_id AND c.c_nameIN (SELECT c.c_name FROM course c,student stu,score s WHERE stu.s_id=s.s_id AND s.c_id=c.c_id AND stu.s_id=‘01’)GROUP BY s.s_id原创 2020-10-05 17:54:53 · 2926 阅读 · 0 评论 -
查询没有学全所有课程的同学的信息
SELECT stu.* FROM student stu WHERE stu.s_id NOT IN (SELECT stu.s_id FROM student stu,score s WHERE stu.s_id=s.s_id GROUP BY s.s_id HAVING COUNT(s.c_id)=3 )原创 2020-10-05 17:54:22 · 11313 阅读 · 0 评论 -
查询学过编号为“01“但是没有学过编号为“02“的课程的同学的信息
SELECT stu.* FROM student stuWHERE stu.s_id NOT IN(SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“张三” AND t.t_id=c.t_id AND c.c_id=s.c_id)AND stu.s_id IN (SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“李四” AND t.t_id=c.t_i原创 2020-10-05 17:53:45 · 3416 阅读 · 0 评论 -
查询学过编号为“01“并且也学过编号为“02“的课程的同学的信息
SELECT stu.* FROM student stuWHERE stu.s_id IN(SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“张三” AND t.t_id=c.t_id AND c.c_id=s.c_id)AND stu.s_id IN (SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“李四” AND t.t_id=c.t_id AND原创 2020-10-05 17:53:18 · 3722 阅读 · 0 评论 -
第二高的薪水
第二高的薪水:Create table If Not Exists Employee (Id int, Salary int)Truncate table Employeeinsert into Employee (Id, Salary) values ('1', '100')insert into Employee (Id, Salary) values ('2', '200')insert into Employee (Id, Salary) values ('3', '300')SELE原创 2020-09-30 11:34:17 · 1799 阅读 · 0 评论 -
直线上的最短距离
直线上的最短距离:CREATE TABLE If Not Exists point (x INT NOT NULL, UNIQUE INDEX x_UNIQUE (x ASC))Truncate table pointinsert into point (x) values ('-1')insert into point (x) values ('0')insert into point (x) values ('2')表 point 保存了一些点在 x 轴上的坐标,这些坐标都是整数。写一个原创 2020-09-30 11:33:18 · 2070 阅读 · 0 评论 -
超出经理收入的员工
超出经理收入的员工:Create table If Not Exists Employee (Id int, Name varchar(255), Salary int, ManagerId int)Truncate table Employeeinsert into Employee (Id, Name, Salary, ManagerId) values ('1', 'Joe', '70000', '3')insert into Employee (Id, Name, Salary, Manag原创 2020-09-30 11:32:32 · 1810 阅读 · 0 评论 -
分数排名
分数排名:Create table If Not Exists Scores (Id int, Score DECIMAL(3,2))Truncate table Scoresinsert into Scores (Id, Score) values ('1', '3.5')insert into Scores (Id, Score) values ('2', '3.65')insert into Scores (Id, Score) values ('3', '4.0')insert into原创 2020-09-30 11:29:16 · 1864 阅读 · 0 评论 -
查询“01“课程比“02“课程成绩高的学生的信息及课程分数
查询"01"课程比"02"课程成绩高的学生的信息及课程分数1.先查出01的所有分数SELECT * FROM score WHERE c_id =‘01’2.再查出02的所有分数SELECT * FROM score WHERE c_id =‘02’3.加上判断条件SELECT a.s_id,a.s_score 语文,b.s_score 数学 FROM(SELECT * FROM score WHERE c_id =‘01’) a,(SELECT * FROM score WHERE c原创 2020-09-30 08:07:40 · 4811 阅读 · 0 评论