In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?
In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?
https://docs.snowflake.com/en/sql-reference/functions/split_part
https://docs.snowflake.com/en/sql-reference/functions/split_part Splits a given string at a specified character and returns the requested part. In this case, SPLIT will return entire string.
Sory, my mistake. B is the right answer. In the above, we can see "Usage notes If the partNumber is out of range, the returned value is an empty string."
Usage notes If the partNumber is out of range, the returned value is an empty string.