首页
科技
登录
6mi
u
盘
搜
搜 索
科技
-- 12、查询至少有一门课与学号为“01“的同学所学相同的同学的信息
-- 12、查询至少有一门课与学号为“01“的同学所学相同的同学的信息
科技
2022-07-20
97
SELECT
DISTINCT
st
.
*
FROM
student st
LEFT
JOIN
score sc
ON
sc
.
s_id
=
st
.
s_id
WHERE
sc
.
c_id
IN
(
SELECT
sc2
.
c_id
FROM
student st2
LEFT
JOIN
score sc2
ON
sc2
.
s_id
=
st2
.
s_id
WHERE
st2
.
s_id
=
'01'
)
转载请注明原文地址:https://blackberry.8miu.com/read-10663.html
最新回复
(
0
)