Calling a function

Call a function inside SELECT.

Calling a function

You call a function inside a SELECT. It returns a value instead of a table.

SELECT get_tax(100);

This query returns the tax for 100.

The expression get_tax(100) is evaluated and returned.

Calling a function — details

A function can be used anywhere in a query: WHERE, SELECT and HAVING.

For example, WHERE get_tax(price) > 10 filters products whose tax is above 10; but wrapping a column in a function can prevent an index from being used.

Exercise Calling a function

Call get_tax(100) inside a SELECT.

Show example solution

SELECT get_tax(100);

Test yourself

Where is a function called?
- Inside SELECT
- Inside ALTER
- Inside DROP
- Inside CREATE
Show answer

Inside SELECT — A function is called inside SELECT.
Add SELECT
```
____ get_tax(100);
```
Show answer
```
SELECT get_tax(100);
```
Calling a function: match the terms

SELECT

query
function

function
parameter

input
value

result

Next lesson: Function vs procedure

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies