sql query on 'select within select'

Question

Question by Dharmendra · May 07, 2010 at 01:14 AM · sql-server-2005 query mysql

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.

0 Show 2

10 |1200 characters needed characters left characters exceeded

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 0

Share

are you using mysql or SQL Server 2005 ?

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

Share

Homework or assignment ?

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

Answer by POLSKA · Oct 03, 2011 at 01:21 PM

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)

0 · Share

10 |1200 characters needed characters left characters exceeded

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

sql query on 'select within select'

1 Reply

Your answer

Follow this Question

Related Questions