SELECT
sno,
sname,
sdept
FROM
student
WHERE
sdept = (
SELECT
sdept
FROM
student
WHERE
sname = '刘晨'
)
7. 查询与“刘晨”在同一个系学习的学生(学号,姓名,系)
最新推荐文章于 2023-05-04 16:38:40 发布
SELECT
sno,
sname,
sdept
FROM
student
WHERE
sdept = (
SELECT
sdept
FROM
student
WHERE
sname = '刘晨'
)