sql 去重、Django去重、列表内字典去重

sql多字段去重

select name,id from table  where id in (
select min(id) from table group by name)

Django去重

orkm_id = (f.id for f in OKRM.objects.filter(Q(user_id=user_id)
                                                         | Q(okrmtouser__user_id=user_id)))
            orkms = OKRM.objects.filter(id__in=orkm_id)

列表内字典去重
bps=[{‘age’:1},{‘age’:1}]
bps_list=[dict(t) for t in set([tuple(d.items()) for d in bps])]