Posted by laredotornado on 10/13/94 11:40

Hello,

I have a table with vacation offier_id's and prices

OFFER_ID PRICE
--------------- --------
1 50.00
2 75.00
1 85.00
1 45.00
2 200.00

I want to write a query to return the offer_id with its lowest price.
The result of scanning the above data would be

OFFER_ID PRICE
--------------- ---------
1 45.00
2 75.00

Using MySQL 4, is there any way to write a single query to do this?
I'm using PHP 4 also.

Thanks, - Dave

• Next in forum: Re: How can I write a min query?
• Prev in forum: query error
• Thread view: How can I write a min query?

[Reply to this message]