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

-1 vote140 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote293 views1 answer
Mysql update table from select on another table
SQL
79 votes558 views6 answers
Grepper code
SQL
0 vote216 views1 answer
MySQL import data from large CSV file
SQL
0 vote211 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote205 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote235 views1 answer
Alter fedora mysql 8.0 user
SQL
2 votes219 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote197 views1 answer
Create table in dbms cmds
SQL
0 vote177 views1 answer
Metada in sql
SQL