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 vote98 views1 answer
Opensuse stop MySQL
SQL
17 votes102 views6 answers
Mysql import sql file
SQL
0 vote109 views1 answer
Google cloud sql postgres url example
SQL
0 vote139 views1 answer
Run docker container with database as rds metabase
SQL
2 votes119 views1 answer
Mysql shell insert into
SQL
0 vote102 views1 answer
Sql case when exists in another table
SQL
1 vote126 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
-2 votes114 views3 answers
Sqlite reset autoincrement
SQL
0 vote102 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote114 views2 answers
Suse stop MySQL
SQL