github.com/dolthub/go-mysql-server@v0.18.0/optgen/cmd/source/unary_aggs.yaml (about)

     1  unaryAggs:
     2  - name:     "AnyValue"
     3    desc:     "returns any single value in the grouped rows"
     4    nullable: true
     5  - name:     "Avg"
     6    desc:     "returns the average value of expr in all rows."
     7    nullable: true
     8  - name:    "BitAnd"
     9    desc:    "returns the bitwise AND of all bits in expr."
    10    retType: "types.Uint64"
    11  - name:    "BitOr"
    12    desc:    "returns the bitwise OR of all bits in expr."
    13    retType: "types.Uint64"
    14  - name:    "BitXor"
    15    desc:    "returns the bitwise XOR of all bits in expr."
    16    retType: "types.Uint64"
    17  - name:    "Count"
    18    desc:    "returns a count of the number of non-NULL values of expr in the rows retrieved by a SELECT statement."
    19    retType: "types.Int64"
    20  - name: "First"
    21    desc: "returns the first value in a sequence of elements of an aggregation."
    22  - name:    "JsonArray"
    23    sqlName: "json_arrayagg"
    24    desc:    "returns result set as a single JSON array."
    25    retType: "types.JSON"
    26  - name: "Last"
    27    desc: "returns the last value in a sequence of elements of an aggregation."
    28  - name: "Max"
    29    desc: "returns the maximum value of expr in all rows."
    30  - name: "Min"
    31    desc: "returns the minimum value of expr in all rows."
    32  - name:     "Sum"
    33    desc:     "returns the sum of expr in all rows"
    34    nullable: false