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

0 vote156 views1 answer
Running query in redshift
SQL
0 vote160 views1 answer
Sql injection mitigation
SQL
0 vote180 views1 answer
Oracle c# multiple update sql
SQL
7 votes157 views1 answer
Safe mode mysql
SQL
0 vote165 views1 answer
Mysql disable query caching
SQL
1 vote191 views3 answers
Connection string mysql
SQL
0 vote170 views1 answer
Oracle last user logon
SQL
2 votes191 views1 answer
Oracle sql merge
SQL
27 votes200 views3 answers
Mysql show tables in database
SQL
0 vote172 views1 answer
Group by two columns postgres
SQL