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 vote224 views1 answer
Drop colum oracle 18c
SQL
0 vote217 views1 answer
Make parameters nullable in sql server
SQL
0 vote213 views1 answer
On delete set default
SQL
3 votes185 views3 answers
Print in pl sql
SQL
6 votes291 views3 answers
Rename column ORACLE
SQL
0 vote280 views1 answer
Best sql collation
SQL
0 vote215 views1 answer
Intellij idea add mysql connector
SQL
0 vote203 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
4 votes196 views2 answers
Sql server date now
SQL
11 votes208 views1 answer
Creating tables in sql with python
SQL