30 Lets looks at performing some queries using mathematical functions. This is not a complete list of the mathematical functions, these are the functions that you will need to be able to use and understand. Refer to the Oracle documentation for a complete list of the functions. The first three functions max, min and avg are grouping functions. They only return one row of data when any query using them is executed.
Lets enter the following statement.
2 Lets enter the next statement. 30 Lets enter the next statement. As you have seen only one row was returned for each of the queries. We can also combine these grouping functions in the one statement. The last two of the mathematical functions that we will discuss here are ceil and floor.