Snippet Name: SELECT within SELECT (SubSelect) Description: Example of doing a SELECT within a SELECT (a subselect). Comment: (none) Language: MYSQL Highlight Mode: MYSQL Last Modified: March 01st, 2009
Description: Example of doing a SELECT within a SELECT (a subselect).
SELECT name FROM listing WHERE population > (SELECT population FROM listing WHERE name='England')