Skip to content

Instantly share code, notes, and snippets.

@francois
Created Apr 28, 2011
Embed
What would you like to do?
SELECT
DISTINCT ON (rs.hotel)
rs.*
FROM
room_sets rs, VALUES(3) AS setup(people)
WHERE
s.people = rs.people
ORDER BY
rs.hotel, rs.price
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment