这个SQL语句该怎么改呢呀

Question

select * from exam_result where math > 80 or select * from exam_result order by chinese desc limit 3;
在exam_result表中查询出数学成绩大于80的或者语文成绩前三的的学生信息

Answer 1

select * from exam_result where math > 80 or chinese in (select chinese from exam_result order by chinese desc limit 3);

有帮助的话，请点采纳该答案~