SQL Query to prevent multiple results of same offer

[Tom Smedley]

Hi There,

I have a travel comparison site and am trying to write a query so that, only 1 record is shown, per departure airport, per accommodation per date. Currently it returns loads of essentially the same offer.

e.g. no same airports, on the same date, in the same hotel.

Currently i'm at:

Code:
SELECT * FROM search_results WHERE departure date = '01-07-2015' AND starrating >= 3 ORDER BY priceperadult ASC


Please help!