Home » SQL & PL/SQL » SQL & PL/SQL » MAX...THIS IS URGENT!!
MAX...THIS IS URGENT!! [message #3997] Thu, 31 October 2002 19:38 Go to next message
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...THIS IS URGENT!! [message #3998 is a reply to message #3997] Thu, 31 October 2002 21:18 Go to previous message
Deepa
Messages: 269
Registered: November 2000
Senior Member
hai,

select suburb,max(maxprice) from table group by suburb

Cheers

Report message to a moderator

Previous Topic: MAX
Next Topic: How do i compare values from 2 columns in 1 table?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 02:27:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.