If you're truly looking for the cheapest, try
But it looks like you want something other than
that from your query with the group by clause.
Thomas Booms EDV wrote:
> I have a Database with some travels (about 1,500,000 ).
> The table looks so:
> organizer text,
> startpoint text,
> destination text,
> startdate date,
> enddate date,
> hotelcode text,
> placingcode text,
> boarding text,
> price double,
> hotelname text,
> hotelresidence text,
> stars text,
> time int,
> journeytype text,
> persons int
> Now I want to compare all Providers and get the cheapest.
> Here's the query:
> select distinct startdate, enddate, boarding, min(price), hotelname,
> hotelresidence, stars, hotelcode, time from table group by startdate,
> enddate, hotelname, hotelresidence order by price
> The result is not fully sorted by the price !
> It looks like some groups which are sorted and not the whole list is
> Am I wrong with the query or is it a bug in MySQL ?
> Yours Thomas Booms