当你想要把查询的不同答案,放到一列时可以用union-为避免错误,建议加上()
查找出1班和2班的前五名的学生
(SELECT NAME FROM S WHERE CLASS=01 ORDER BY SCORE DESC LIMIT 5)
UNION
(SELECT NAME FROM S WHERE CLASS=02 ORDER BY SCORE DESC LIMIT 5)
当你想要把查询的不同答案,放到一列时可以用union-为避免错误,建议加上()
查找出1班和2班的前五名的学生
(SELECT NAME FROM S WHERE CLASS=01 ORDER BY SCORE DESC LIMIT 5)
UNION
(SELECT NAME FROM S WHERE CLASS=02 ORDER BY SCORE DESC LIMIT 5)