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 votes362 views2 answers
Doublon sql
SQL
8 votes336 views1 answer
Oracle create datafile
SQL
1 vote365 views1 answer
Concat first name and last name in mysql
SQL
7 votes302 views4 answers
How to reset the identity column in sql server
SQL
7 votes332 views2 answers
What is sql clause
SQL
0 vote344 views1 answer
Oracle cpu metric
SQL
0 vote371 views1 answer
How to compile a function in oracle
SQL
0 vote318 views1 answer
Cast as decimal postgresql
SQL
0 vote330 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote310 views2 answers
Mysql order by date asc null last
SQL