sqlalchemy: distinct only on one column

Question

My table looks like this:

    title      |    slug
------------------------------
The Title      | the-title
Another Title  | another-title
another title  | another-title

I want to select by distinct slug, but also want the title returned as part of the results. Which title gets returned for multiple matches, I don't care.

So my results look like this:

[('The Title', 'the-title'), ('Another Title', 'another-title')]

Answer 1

You probably want to do something like:

session.query(func.max(Table.title), Table.slug).group_by(Table.slug).all()

Answer 2

You can also solve this with:

session.query(Table.title, Table.slug).distinct(Table.slug)

This also allows you to return additional fields (say you wanted to see Table.id) in the same .query() field list, without requiring a separate subquery.