SELECT
sname,
sage
FROM
student
WHERE
sage < ALL (
SELECT
sage
FROM
student
WHERE
sdept = 'CS '
)
AND sdept <> 'CS '
3. 查询非计算机科学系中比计算机科学系所有学生年龄都小的学生姓名及年龄。
最新推荐文章于 2023-05-09 07:30:00 发布
SELECT
sname,
sage
FROM
student
WHERE
sage < ALL (
SELECT
sage
FROM
student
WHERE
sdept = 'CS '
)
AND sdept <> 'CS '