Tags

links:
http://stackoverflow.com/questions/966176/select-distinct-on-one-column

summary:
– do a subquery using group-by to get the min or max id
– then use that id to lookup the records

Advertisements