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

22 votes296 views4 answers
Mysql reset auto increment id
SQL
2 votes288 views1 answer
Query to find table size in oracle 12c
SQL
0 vote302 views2 answers
Disadvantages of stored procedures sql
SQL
1 vote293 views1 answer
Increase existing date in sql oracle
SQL
6 votes284 views1 answer
Postgresql get year
SQL
8 votes316 views1 answer
My sql version
SQL
0 vote301 views2 answers
Soql last year
SQL
1 vote331 views1 answer
Oracle see column type
SQL
0 vote275 views2 answers
Sql query unique
SQL
1 vote281 views1 answer
Oracle sql create or replace view
SQL