Description

label
Specifies the label for the RETURN statement. The label name cannot be the same as the routine name or another label within the same scope. For more information, see Handling errors and warnings.
expression
Specifies a value that is returned from the routine:
NULL
The null value is returned from the SQL function. NULL is not allowed in SQL procedures.
query-expression
Specifies a query-expression value that is returned from the routine. The query-expression is a common-table-expression or fullselect. A query-expression is only allowed in a table function.