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')
posted on 2018-05-11 14:51 大稀饭 阅读(79) 评论(0) 收藏 举报