Table valued functions in sql

-- create function
CREATE [OR ALTER] FUNCTION <FUNCTION NAME> (@<PARAMETER NAME1<DATATYPE>
[SIZE], .......)
RETURNS TABLE
AS
RETURN( <SELECT QUERY/ STATEMENT>)

-- call function
SELECT * FROM <FUNCTION NAME> (VALUE / VALUES);

Similar codes

10 votes135 views1 answer
Oracle dependency
SQL
0 vote167 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote175 views1 answer
Sql waitfor
SQL
0 vote146 views1 answer
Sql with example
SQL
0 vote156 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote161 views1 answer
Copy data from one postgres container to another
SQL
4 votes148 views2 answers
Sql server date now
SQL
0 vote140 views1 answer
How to print out column name differently in mysql
SQL
2 votes150 views2 answers
Oracle multiple insert
SQL
1 vote182 views1 answer
Sql server loop over query
SQL