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 vote360 views1 answer
Phpmyadmin tabellentyp ändern
SQL
3 votes353 views1 answer
Ssh check mysql version
SQL
0 vote398 views1 answer
Google sheets data validation custom formula filter
SQL
25 votes407 views6 answers
Import database mysql command line
SQL
0 vote348 views1 answer
Oracle merge insert if not exists
SQL
0 vote366 views2 answers
How to create a table from another table in sql derby
SQL
13 votes380 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote369 views1 answer
Sparql if bound query
SQL
0 vote368 views1 answer
How to search query in python3 sqlite3
SQL
2 votes404 views2 answers
Select sqlite3.OperationalError: no such column:
SQL