I have a Database with some travels (about 1,500,000 ).
The table looks so:
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