SQL - Table Function

1 - About

PIPELINED functions (or table function) operate like a table and is a good workaround to Stored Procedures

They are useful if there is a need for a data source other than a table in a select statement.

3 - Syntax

Without the table(…) wrapper

With the table wrapper:

Not implemented:

Example with table wrapper:


SELECT W FROM tablefunc(a,b)


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap