求一個(gè)SQL語(yǔ)句

select name from
student2 where subject = "語(yǔ)文" and score in
(select min(score) from student2 where name != "李四");

SELECT name FROM scores WHERE score = (SELECT MIN(score) FROM scores WHERE name <> '李四' and class = '語(yǔ)文') and name <> '李四' and class = '語(yǔ)文'

感覺(jué)有點(diǎn)長(zhǎng)，沒(méi)想到更好的方法。

SELECT Name FROM table WHERE Score = (SELECT MIN(Score) FROM table WHERE Class = '語(yǔ)文') AND Name <> '李四' AND Class = '語(yǔ)文';

SELECT
  t.name
FROM
  table as t
WHERE
  t.name!='李四' and t.score=
                         (SELECT
                            min(t.score)
                          FROM
                            table as t
                          WHERE
                            t.subject='語(yǔ)文')