> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# AggregateGroupByRequest

> AggregateGroupByRequest — Kinetica Node.js API

interface AggregateGroupByRequest \{\
&#x20;[column\_names](#column_names): string\[];\
&#x20;[encoding](#encoding)?: string;\
&#x20;[limit](#limit)?: number;\
&#x20;[offset](#offset)?: number;\
&#x20;[options](#options)?: Record\<string, string>;\
&#x20;[table\_name](#table_name): string;\
}

<ul>
  <li>Defined in [src/types.ts:507](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L507)</li>
</ul>

##### Index

### Properties

[column\_names](#column_names) [encoding?](#encoding) [limit?](#limit) [offset?](#offset) [options?](#options) [table\_name](#table_name)&#x20;

## Properties

### column\_names

column\_names: string\[]

List of one or more column names, expressions, and aggregate expressions.

<ul>
  <li>Defined in [src/types.ts:511](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L511)</li>
</ul>

### `Optional`encoding

encoding?: string

Specifies the encoding for returned records.

<ul>
  <li>Defined in [src/types.ts:526](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L526)</li>
</ul>

### `Optional`limit

limit?: number

A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the max\_get\_records\_size parameter in the server configuration. Use `has_more_records` to see if more records exist in the result to be fetched, and `offset` and `limit` to request subsequent pages of results.

<ul>
  <li>Defined in [src/types.ts:524](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L524)</li>
</ul>

### `Optional`offset

offset?: number

A positive integer indicating the number of initial results to skip (this can be useful for paging through the results).

<ul>
  <li>Defined in [src/types.ts:513](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L513)</li>
</ul>

### `Optional`options

options?: Record\<string, string>

Optional parameters.

<ul>
  <li>Defined in [src/types.ts:528](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L528)</li>
</ul>

### table\_name

table\_name: string

Name of an existing table or view on which the operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules.

<ul>
  <li>Defined in [src/types.ts:509](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L509)</li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.