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 hospital group by city" should work too, shouldn't it?
-- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php