cycquery.ops.Distinct

class Distinct(cols)

Bases: QueryOp

Get distinct rows.

Parameters:

cols (Union[str, List[str]]) – Columns to use for distinct.

Examples

>>> Distinct("person_id")(table)
>>> Distinct(["person_id", "visit_id"])(table)

Methods

__call__(table)

Process the table.

Parameters:

table (Union[Select, Subquery, Table, DBTable]) – Table on which to perform the operation.

Returns:

Processed table.

Return type:

sqlalchemy.sql.selectable.Subquery