sql query on 'select within select'

Question

question

Dharmendra asked May 7, '10

sql query on 'select within select'

this is table : bbc(name, region, area, population, gdp)

Some countries have populations more than three times that of any of their neighbours (in the same region). Give the countries and regions.

this is what i am trying : select distinct a.name, a.region from bbc a where a.name = any(select b.name from bbc b where a.name!=b.name and a.region=b.region and a.population> 3 * b.population)

but there is still some mistakes, i couldn't find

please try to solve it.

sql-server-2005 query mysql

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Squirrel 1 · May 07, 2010 at 03:09 AM

are you using mysql or SQL Server 2005 ?

0 ·

Squirrel 1 · May 07, 2010 at 03:51 AM

Homework or assignment ?

0 ·

Answer 1 · 2011-10-03T13:21:52Z

POLSKA answered Oct 3, '11

select x.name,x.region from bbc x where (x.population/3)>(select MAX(y.population) from bbc y where x.region=y.region and y.name != x.name)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question