Table values functions in SQL

CREATE FUNCTION udfProductInYear (
    @model_year INT
)
RETURNS TABLE
AS
RETURN
    SELECT 
        product_name,
        model_year,
        list_price
    FROM
        production.products
    WHERE
        model_year = @model_year;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

8 votes351 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote349 views1 answer
Running query in redshift
SQL
3 votes416 views2 answers
Wp do sql query from function
SQL
0 vote315 views1 answer
Sql random decimal
SQL
3 votes404 views2 answers
See mysql users ubuntu
SQL
2 votes335 views1 answer
Mysql find tables with name
SQL
6 votes315 views1 answer
Phpmyadmin reset root password
SQL
0 vote325 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote346 views1 answer
Ms sql database data size
SQL
0 vote358 views1 answer
SELECT statement to find the specific cell in database table
SQL