SELECT name FROM bbc WHERE gdp > ALL (SELECT gdp FROM bbc WHERE region = ‘Africa‘ AND gdp<>NULL)
错的, <>不连接null
SELECT name FROM bbc WHERE gdp > (SELECT MAX(gdp) FROM bbc WHERE region = ‘Africa‘)
Mysql
原文:https://www.cnblogs.com/yellowall/p/8992479.html