Day 10 — SAP HANA Functions

What is a Function in SAP HANA? Why do we use it?

A Function is a database object that performs calculations and returns a single value or a table. 1. What is a Function? a. Performs calculations. b. Returns a value. c. Used inside SQL statements. d. Can be built-in or user-defined. e. Improves code reusability. 2. Common Built-in Functions a. SUM() b. COUNT() c. AVG() d. MAX() e. MIN() 3. Advantages of Functions a. Simplifies calculations. b. Reduces coding effort. c. Improves readability. d. Reuses business logic. e. Improves SQL performance.

• A Sales Dashboard needs Total Sales. • SUM() calculates total revenue. • COUNT() displays total orders. • AVG() shows average order value. • MAX() displays the highest sales amount.

1. What is a Function? 2. Why do we use Functions? 3. Name five built-in Functions. 4. What is the difference between a Function and a Procedure? 5. Give one real-time example.