Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

ELT

Returns the Nth value in its list of arguments.

Syntax

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

SELECT ELT(2, 'foo', 'bar', 'baz') AS Result;
****
+-----------------------------+
| Result                      |
+-----------------------------+
| bar                         |
+-----------------------------+
SELECT ELT(0, 'housewares', 'textiles', 'appliances', 'lamps') AS Product_Type;
****
+------------------------------+
| Product_Type                 |
+------------------------------+
| NULL                         |
+------------------------------+
1 row in set (295 ms)
SELECT ELT(5, 'name', 'code', 'location') AS Company_Details;
****
+------------------------------+
| Company_Details              |
+------------------------------+
| NULL                         |
+------------------------------+
1 row in set (320 ms)