Home » SQL & PL/SQL » SQL & PL/SQL » Plz provide sol. for this Sql Query  () 1 Vote
Plz provide sol. for this Sql Query [message #210914] Sat, 23 December 2006 03:45 Go to next message
oracle_faqs
Messages: 5
Registered: December 2006
Location: New Delhi
Junior Member

Structure of the table is :

bbc(name, region, area, population, gdp)

& the query is:

For each region show the region and number of countries with populations of at least 10 million.

the sol. i have worked out is:

select region , count(name)
from bbc
group by region
having sum(population) >= 10000000;

But this is not working.
Plz help me !!!!!!!!!!!!!!!1
icon2.gif  Re: Plz provide sol. for this Sql Query [message #210923 is a reply to message #210914] Sat, 23 December 2006 05:40 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
and the error which you get is?
Previous Topic: Exception problem (merged)
Next Topic: copy table from one server to another server
Goto Forum:
  


Current Time: Fri Dec 09 23:12:21 CST 2016

Total time taken to generate the page: 0.09627 seconds