What type of function returns one value for each invocation?
What type of function returns one value for each invocation?
A scalar function returns one value for each invocation. This type of function operates on a single value or a single set of values from a row and returns a single value as the result.
A scalar function is a function that returns one value per invocation; in most cases, you can think of this as returning one value per row. This contrasts with Aggregate Functions, which return one value per group of rows.
B is correct https://docs.snowflake.com/en/sql-reference/functions