AIL PROTECTED]]
Sent: Wednesday, October 09, 2002 8:45 AM
To: [EMAIL PROTECTED]
Subject: Question about solving a query !
Hello,
I have a problem to treat a query with MySQL because MySQL does not permit
nested SELECT clauses.
The schema of the table is :
Hospital
num | name | c
on about solving a query !
Hello,
I have a problem to treat a query with MySQL because MySQL does not permit
nested SELECT clauses. The schema of the table is :
Hospital
num | name | city| numbeds
10 | Clairval| Marseille
Myoung-Ah KANG wrote:
>The query is: "For each city, what is the name of the hospital having the
>highest number of beds ? ' .
>
>Select name From Hospital Where (city, numbeds) In
>(Select city, MAX(numbeds) From Hospital Group By city);
>
>
>
"select name, city, max(numbeds) from
Hello,
I have a problem to treat a query with MySQL because MySQL does not permit
nested SELECT clauses.
The schema of the table is :
Hospital
num | name | city| numbeds
10 | Clairval| Marseille | 70
20 | Notre-Dame | Ma
