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 vote158 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote208 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote147 views1 answer
Sql server query database space available
SQL
0 vote148 views2 answers
Script all indexes in a database
SQL
7 votes197 views2 answers
Oracle foreign key reference table
SQL
0 vote122 views1 answer
Ms sql unique
SQL
13 votes140 views2 answers
Sqlite rename column
SQL
0 vote149 views2 answers
Generate sql trigger through ef migration
SQL
16 votes163 views3 answers
Get count of duplicate records
SQL
13 votes198 views3 answers
Mysqldump structure only
SQL