Main NavigationHome Documentation

Appearance

Sidebar Navigation

Quick start

Introduction

Create new project

Create application

Write first view

Render html file

Load static file

Variables in html

First model

Admin panel

Simple queryset

Essentials

Models

Introduction to models

Field types

Relationships

Meta class

Admin

Introduction to admin

Register model

ModelAdmin

Actions

QuerySet

Making queries

Lookup expressions

CRUD

Views

Introduction to views

Request methods

Function based views

URLs

View decorators

File uploads

Class based views

Render html file

Generic views

Mixins

Templates

Tags and filters

Humanization

Layout

Component

Forms

Introduction to forms

Usage

Forms for models

Authentication

Caching

Pagination

Sessions

Static files management

Validators

Signals

Middleware

Advanced

Models

Custom field

API reference

Model fields

AutoField

BinaryField

BooleanField

CharField

DateField

DateTimeField

DecimalField

DurationField

EmailField

FileField

FilePathField

FloatField

GenericIPAddressField

ImageField

IntegerField

JSONField

SlugField

TextField

TimeField

URLField

UUIDField

ForeignKey

ManyToManyField

OneToOneField

Model field options

null

blank

choices

db_column

db_comment

db_index

db_tablespace

default

editable

error_messages

help_text

primary_key

unique

unique_for_day

unique_for_month

unique_for_year

verbose_name

validators

Model Meta options

abstract

app_label

base_manager_name

db_table

db_table_comment

db_tablespace

default_manager_name

default_related_name

get_latest_by

managed

order_with_respect_to

ordering

permissions

default_permissions

proxy

required_db_features

required_db_vendor

select_on_save

indexes

unique_together

index_together

constraints

verbose_name

verbose_name_plural

label

label_lower

QuerySet methods

all

filter

exclude

annotate

alias

order_by

reverse

distinct

values

values_list

dates

datetimes

none

union

intersection

difference

select_related

prefetch_related

extra

defer

only

using

select_for_update

raw

get

create

get_or_create

update_or_create

bulk_create

bulk_update

count

in_bulk

iterator

latest

earliest

first

last

aggregate

exists

contains

update

delete

as_manager

explain

QuerySet field lookups

exact

iexact

contains

icontains

in

gt

gte

lt

lte

startswith

istartswith

endswith

iendswith

range

date

year

iso_year

month

day

week

week_day

iso_week_day

quarter

time

hour

minute

second

isnull

regex

iregex

QuerySet aggregation functions

Avg

Count

Max

StdDev

Sum

Variance

QuerySet others

AND

OR

XOR

Q

Prefetch

prefetch_related_objects

FilteredRelation

F

Func

Aggregate

Value

ExpressionWrapper

Subquery

Exists

Cast

Coalesce

Collate

Greatest

JSONObject

Least

NullIf

Extract

Now

Trunc

View HttpRequest attributes

scheme

body

path

path_info

method

encoding

content_type

content_params

GET

POST

COOKIES

FILES

View HttpRequest methods

get_host()

get_port()

get_full_path()

get_full_path_info()

build_absolute_uri()

get_signed_cookie()

is_secure()

accepts()

read()

readline()

readlines()

__iter__()

View decorators

require_http_methods

login_required

View generics

TemplateView

RedirectView

DetailView

ListView

FormView

CreateView

UpdateView

DeleteView

ArchiveIndexView

YearArchiveView

MonthArchiveView

WeekArchiveView

DayArchiveView

TodayArchiveView

DateDetailView

Validators

RegexValidator

EmailValidator

URLValidator

validate_email

validate_slug

validate_unicode_slug

validate_ipv4_address

validate_ipv6_address

validate_ipv46_address

validate_comma_separated_integer_list

int_list_validator

MaxValueValidator

MinValueValidator

MaxLengthValidator

MinLengthValidator

DecimalValidator

FileExtensionValidator

validate_image_file_extension

ProhibitNullCharactersValidator

StepValueValidator

On this page

Table of Contents for current page

QuerySet aggregation functions API reference

Avg
Count
Max
Min
StdDev
Sum
Variance

Edit this page on GitHub

Previous pageiregex

Next pageAvg

QuerySet aggregation functions API reference ​

QuerySet aggregation functions API reference