On Tue, May 08, 2012 at 05:20:03AM -0700, Eduardo wrote: > Hi, > Is there any function in sqlalchemy that filters out duplicates? > For example the following rows satisfy a query: > 1. (john, 23 , lpgh ) > 2.(steve , 35 , dbr ) > 3. (john ,76, qwe) > 4. (mark, 35, epz) > I would like that my query results contain only one row with john (either 1 > or 3 which one is not important) or with 35 (either 2 or 4). > I tried with distinct(col) but it could not do the work. You could try DISTINCT ON in combination with a UNION... maybe. DISTINCT ON is documented here: http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.distinct and I'm not sure which dialects support this, apart from PostgreSQL.
> Thanks > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/xnt0Zo5tSPUJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -Ryan -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
