OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » MAX

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MAX [message #22834]

Thu, 31 October 2002 18:56

HC
Messages: 2
Registered: October 2002

Junior Member

Hi all

Here is what I have:

SUBURB MAXPRICE
-------------------- ----------
bondi 356885
maroubra 220066
randwick 228068
randwick 283968
randwick 429719
randwick 237671

But I need to choose max price in each suburb which is:

SUBURB MAXPRICE
-------------------- ----------
bondi 356885
maroubra 220066
randwick 429719

How can I do it?

Thanks in advance
HC

Report message to a moderator

Re: MAX [message #22837 is a reply to message #22834]

Thu, 31 October 2002 21:07

Dan
Messages: 61
Registered: February 2000

Member

hello HC,

Select max(price),suburb from table group by suburb

regards
dan

Report message to a moderator

Previous Topic:	IF Statement syntax
Next Topic:	MAX...THIS IS URGENT!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 19:42:28 CDT 2024