Mysql

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)    收藏  举报