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

1 vote348 views1 answer
Nullif postgresql
SQL
0 vote318 views1 answer
Less than and between in sql query
SQL
1 vote319 views1 answer
Mysql how to reset primary key
SQL
0 vote316 views1 answer
How to export only procedures mysql
SQL
0 vote409 views1 answer
Sp help text in postgresql
SQL
3 votes349 views4 answers
Truncate syntax in sql
SQL
0 vote351 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote337 views1 answer
Sql delete caracter list
SQL
0 vote340 views1 answer
Gcloud sql instance list
SQL
5 votes328 views3 answers
Db begintransaction laravel
SQL