Compare 1 row (namely a field) with n other fields, how?

Question

SQL

Hello, I have this request:

SELECT name FROM world
WHERE gdp > (SELECT gdp FROM world WHERE continent = 'Europe')

But it doesn't work because the parenthesized SELECT returns a lot of rows.
How can this task be accomplished?
PS in sql I'm still 0, thank you very much for your help!

Answer 1

Depends on what you want to select and what your query returns. If you need to select records whose gdp is greater than the maximum for records with continent = 'Europe', then this is done

SELECT name FROM world
WHERE gdp > (SELECT MAX(gdp) FROM world WHERE continent = 'Europe')

If something else - specify what you store and what you want.
And, it would also be nice to clarify what you have - MS SQL, MySQL or something else