select * from exam_result where math > 80 or select * from exam_result order by chinese desc limit 3;
在exam_result表中查询出数学成绩大于80的或者语文成绩前三的的学生信息
select * from exam_result where math > 80 or chinese in (select chinese from exam_result order by chinese desc limit 3);
有帮助的话，请点采纳该答案~
select * from exam_result where math > 80 union select * from exam_result order by chinese desc limit 3;
select * from exam_result where math > 80 or chinese in （select chinese from exam_result order by chinese desc limit 3);
-- 出数学成绩大于80
select * from exam_result
where math > 80
union all
-- 英语成绩前三
select * from exam_result
order by chinese desc limit 3 ;