---
title: ES|QL ROW command
description: 
url: https://www.elastic.co/elastic/docs-builder/docs/3016/reference/query-languages/esql/commands/row
products:
  - Elasticsearch
---

# ES|QL ROW command
<applies-to>
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
</applies-to>

The `ROW` source command produces a row with one or more columns with values
that you specify. This can be useful for testing.

## Syntax

```esql
ROW column1 = value1[, ..., columnN = valueN]
```


## Parameters

<definitions>
  <definition term="columnX">
    The column name.
    In case of duplicate column names, only the rightmost duplicate creates a column.
  </definition>
  <definition term="valueX">
    The value for the column. Can be a literal, an expression, or a
    [function](/elastic/docs-builder/docs/3016/reference/query-languages/esql/esql-functions-operators#esql-functions).
  </definition>
</definitions>


## Examples

The following examples demonstrate common `ROW` patterns.

### Create a row with literal values

```esql
ROW a = 1, b = "two", c = null
```


| a:integer | b:keyword | c:null |
|-----------|-----------|--------|
| 1         | "two"     | null   |


### Create multivalued columns

Use square brackets to create a column with multiple values:
```esql
ROW a = [2, 1]
```


### Use functions as values

```esql
ROW a = ROUND(1.23, 0)
```