SELECT * FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select DISTINCT (st.s_id),st.s_name from student st,score sc WHERE sc.s_id=st.s_id) tb2 WHERE tb1.s_id=tb2.s_id

这是一个 SQL 查询语句，其目的是查询学号为"01"的学生在成绩表中所有课程的成绩以及该学生的姓名。具体实现是通过将学号为"01"的学生在成绩表中的课程ID与所有学生的学号和姓名进行关联，然后进行查询。其中，第一个子查询(SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01")用于查询学号为"01"的学生在成绩表中的课程ID，第二个子查询(select DISTINCT (st.s_id),st.s_name from student st,score sc WHERE sc.s_id=st.s_id)用于查询所有学生的学号和姓名，最后在两个子查询的结果中通过学号进行匹配，得到该学生在所有课程的成绩以及姓名。

SELECT * FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select st.s_id,st.s_name,sc.c_id,sc.s_score from student st inner join score sc on sc.s_id=st.s_id) tb2 WHERE tb1.s_id=tb2.s_id > 1054 - Unknown column 'tb1.s_id' in 'where clause'

根据您提供的 SQL 语句来看，似乎存在一个语法错误。在第二个 WHERE 子句中，您引用了一个未定义的列 `tb1.s_id`。这是因为在您的查询中，`tb1` 子查询仅包含 `c_id` 列，而不包含 `s_id` 列。如果您想要连接 `tb1` 和 `tb2` 子查询，您需要确保它们都具有相同的连接列，然后将它们包装在一个更大的子查询中。例如，您可以尝试以下查询： ``` SELECT tb2.s_id, tb2.s_name, tb2.c_id, tb2.s_score FROM (SELECT c_id, s_id FROM student st INNER JOIN score sc ON sc.s_id = st.s_id WHERE st.s_id = '01') tb1 INNER JOIN (SELECT st.s_id, st.s_name, sc.c_id, sc.s_score FROM student st INNER JOIN score sc ON sc.s_id = st.s_id) tb2 ON tb1.s_id = tb2.s_id WHERE tb2.s_score > 1054 ``` 这个查询首先选出学号为 `'01'` 的学生所选的所有课程，并将结果存储在 `tb1` 子查询中。然后，它将 `tb1` 和 `tb2` 子查询连接起来，并选出成绩大于 `1054` 的所有记录。

SELECT DISTINCT tb2.s_name FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select st.s_id,st.s_name,sc.c_id,sc.s_score from student st inner join score sc on sc.s_id=st.s_id) tb2 WHERE tb1.c_id=tb2.c_id

这个 SQL 查询将返回学号为 "01" 的学生所选的所有课程的学生名字。它使用了两个子查询 `tb1` 和 `tb2`，并通过 `c_id` 列将它们联接起来，最后从 `tb2` 子查询中选择不同的学生名字。具体来说，`tb1` 子查询选出了学号为 "01" 的学生所选的所有课程的课程 ID，存储在 `c_id` 列中。`tb2` 子查询选出了所有学生的学号、姓名、所选课程的课程 ID 和成绩。两个子查询通过 `c_id` 列联接起来，找出所有选了这些课程的学生信息，最后通过 `DISTINCT` 关键字去重，只返回不同的学生名字。需要注意的是，如果有多个学生选了相同的课程，那么这个查询将返回这些学生的并集的不同的名字。

阅读全文

SELECT * FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select DISTINCT (st.s_id),st.s_name from student st,score sc WHERE sc.s_id=st.s_id) tb2 WHERE tb1.s_id=tb2.s_id

SELECT * FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select st.s_id,st.s_name,sc.c_id,sc.s_score from student st inner join score sc on sc.s_id=st.s_id) tb2 WHERE tb1.s_id=tb2.s_id > 1054 - Unknown column 'tb1.s_id' in 'where clause'

SELECT DISTINCT tb2.s_name FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select st.s_id,st.s_name,sc.c_id,sc.s_score from student st inner join score sc on sc.s_id=st.s_id) tb2 WHERE tb1.c_id=tb2.c_id

相关推荐

数据库表数据的查询操作.docx

学生_课程_成绩_教师50个常用sql

经典SQL面试题.doc

SELECT DISTINCT tb2.* FROM (SELECT c_id FROM student st INNER JOIN score sc ON sc.s_id =st.s_id where st.s_id ="01") tb1,(select * from student st,score sc WHERE sc.s_id=st.s_id) tb2 WHERE tb1.s_id=tb2.s_id > 1060 - Duplicate column name 's_id' > 查询时间: 0s

2、查询"01"课程比"02"课程成绩低的学生的信息及课程分数 SELECT st.s_name, sc.s_score,sc.c_id FROM student st INNER JOIN score sc ON st.s_id = sc.s_id WHERE sc.c_id=01 < ALL (SELECT s_score FROM score WHERE c_id = 02)and sc.c_id !=02 and sc.c_id !=03 帮我修改

8、查询没学过"张三"老师讲授的任一门课程的学生姓名 select * from student st inner join score sc on st.s_id =sc.s_id inner join course co on sc.c_id=co.c_id inner join teacher te on co.t_id=te.t_id where te.t_name ="张三"

select s_name from student, (select st.s_name from score sc inner JOIN student st ON st.s_id =sc.s_id INNER JOIN course c ON sc.c_id=c.c_id) demo1 where student.s_name = demo1.s_name报错Column 's_name' in field list is ambiguous

select * from student st inner join score sc on st.s_id=sc.s_id where sc.c_id="01"and sc.c_id !="02" -- -- -- 10、查询没有学全所有课程的同学的信息 修改符合这个语句

SELECT student.s_name FROM student, (SELECT DISTINCT st.s_name, sc.c_id FROM score sc INNER JOIN student st ON st.s_id = sc.s_id INNER JOIN course c ON sc.c_id = c.c_id) demo1 WHERE student.s_name = demo1.s_name学生表中有没有课程的学生,怎么修改sql能查询出来

SELECT st.s_name, MIN(sc.s_score) AS min_score FROM student st LEFT JOIN score sc ON st.s_id = sc.s_id AND sc.s_score < 60 GROUP BY st.s_name HAVING COUNT(*) >= 2;如果有学生没有参加考试

select group_concat(sc2.c_id) from student st2 left join score sc2 on sc2.s_id=st2.s_id where st2.s_id ='01'

select s.* from student s inner join sc ,course c ,teacher t on sc.SNO =s.SNO and c.CNO =sc.CNO and t.TNO =c.TNO where t.TNAME = '张三' order by sc.SCORE desc limit 1,1 这串sql有什么问题，怎么解决

select s.SId,Sname,avg(score) average from Student s inner join(select SId,score,count(*) count1 from SC111 c where score <60 group by SId,score having count(*)>=2) ddd on s.SId=ddd.SId

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 该程序的功能是：

查询成绩小于80的男学生的学号，姓名,课程,成绩。 select xs.学号,姓名,课程名,成绩 from （ ） inner join （ ） using (学号) inner join （ ） using(课程号) where 性别=1 and 成绩<80;

李白高力士脱靴李白贺知章告别课本剧.pptx

最新推荐

李白高力士脱靴李白贺知章告别课本剧.pptx

Spring Cloud 学习过程记录，含多方面知识及系列教程.zip

C语言项目之超级万年历系统源码.zip

高清艺术文字图标资源，PNG和ICO格式免费下载

管理建模和仿真的文件

DMA技术：绕过CPU实现高效数据传输

SGM8701电压比较器如何在低功耗电池供电系统中实现高效率运作？

mui框架HTML5应用界面组件使用示例教程

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

【数据传输高速公路】：总线系统的深度解析

select * from student st inner join score sc on st.s_id=sc.s_id where sc.c_id="01"and sc.c_id !="02" -- -- -- 10、查询没有学全所有课程的同学的信息修改符合这个语句

select s.SId,Sname,avg(score) average from Student s inner join(select SId,score,count() count1 from SC111 c where score <60 group by SId,score having count()>=2) ddd on s.SId=ddd.SId

查询成绩小于80的男学生的学号，姓名,课程,成绩。 select xs.学号,姓名,课程名,成绩 from （） inner join （） using (学号) inner join （） using(课程号) where 性别=1 and 成绩<80;