-
Inner and outer select
In my SQL learning I have reached to the following question:
Find the largest country in each region
The table bbc has (name, region, population)
The answer is
SELECT region, name, population FROM bbc x
WHERE population >= ALL
(SELECT population FROM bbc y
WHERE y.region=x.region
AND population>0)
I couldn't understand it and need an explanation guys
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|