HAVING IN SQL 
--Count of Person by gender if number of person is greater than 1 

SELECT gender, COUNT('gender') as count
FROM Person
GROUP BY gender 
HAVING count > 1;

HAVING IN DJANGO

Person.objects.annotate(count=Count('gender')).values('gender', 'count').filter(count__gt=1)
Prev next