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 vote236 views1 answer
Oracle list of long running queries
SQL
0 vote252 views1 answer
Postgres regex word boundary
SQL
0 vote218 views1 answer
Postgresql import data from csv
SQL
3 votes238 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote231 views1 answer
Original Query
SQL
3 votes218 views1 answer
System.debug apex
SQL
10 votes242 views1 answer
Oracle dependencies table
SQL
4 votes225 views1 answer
Select nls_date_format
SQL
3 votes230 views2 answers
Pl sql escape '
SQL
0 vote267 views1 answer
Sql datum formatieren
SQL