distinctΒΆ

You can use distinct clauses with the following queries:

>>> await Band.select(Band.name).distinct()
[{'title': 'Pythonistas'}]

This is equivalent to SELECT DISTINCT name FROM band in SQL.