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 vote270 views1 answer
Oracle last user logon
SQL
1 vote307 views1 answer
Postgresql update auto_increment value
SQL
0 vote372 views1 answer
Insert using condition postgres
SQL
0 vote343 views2 answers
How to get the date from datetime in mysql
SQL
0 vote315 views1 answer
On update current_timestamp jpa
SQL
0 vote365 views1 answer
How to pass list as parameter in SQL query
SQL
4 votes392 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote349 views1 answer
How to list function in psql
SQL
1 vote327 views1 answer
Add constraint sql
SQL
0 vote319 views1 answer
Postgres 11 add primary key
SQL