Equivalent of select distinct in sql

How about this?

unique_names = []
all_names = list(app_tables.tablewithnames.search())
for r in all_names:
    unique_names.append(r['Name'])
print set(unique_names)