SELECT
sname,
sage
FROM
student
WHERE
sage < ANY (
SELECT
sage
FROM
student
WHERE
sdept = 'CS '
)
AND sdept <> 'CS '
4. 查询非计算机科学系中比计算机科学系任意一个学生年龄小的学生姓名和年龄
最新推荐文章于 2021-07-19 18:48:44 发布
SELECT
sname,
sage
FROM
student
WHERE
sage < ANY (
SELECT
sage
FROM
student
WHERE
sdept = 'CS '
)
AND sdept <> 'CS '