Oracle query help: subquery or having count()?

Frederic

New member
A table contains business_name and town. There are 45 businesses but only 24 towns. I would like a query that lists the business_name and town for only towns that have more than one business_name.

I should know how to do this, but I'm drawing a blank...
 
Back
Top