# ELT

Returns the Nth value in its list of arguments.

## Syntax

```sql
ELT (pos, val, [val, [val...]])

```

## Arguments

* pos: one-indexed argument position
* val: any number of values.

## Remarks

* The function returns `NULL` if `pos` is less than 1 or greater than the number of values specified as arguments.

## Examples

```sql
SELECT ELT(2, 'foo', 'bar', 'baz') AS Result;

```

```output

+-----------------------------+
| Result                      |
+-----------------------------+
| bar                         |
+-----------------------------+

```

```sql
SELECT ELT(0, 'housewares', 'textiles', 'appliances', 'lamps') AS Product_Type;

```

```output

+------------------------------+
| Product_Type                 |
+------------------------------+
| NULL                         |
+------------------------------+
1 row in set (295 ms)

```

```sql
SELECT ELT(5, 'name', 'code', 'location') AS Company_Details;

```

```output

+------------------------------+
| Company_Details              |
+------------------------------+
| NULL                         |
+------------------------------+
1 row in set (320 ms)

```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/conditional-functions/elt/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/conditional-functions/elt/)

(An index of the documentation is available at /llms.txt)