![]() |
|||
|
![]() |
![]() |
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
![]() Term: AVG
Definition: SELECT AVG( value) The value parameter is typically a single column in a table, but can also be an expression or formula which is evaluated. For example, multiple columns in one or more tables could be summed and then averaged. Example Usage: SELECT AVG(price) FROM product_table; In the example above, the AVG() function returns the average cost of all of the values in the price column. This is an example of using a formula with the AVG() function to compute the average mileage expense: SELECT AVG(mileage * 0.30) as "Average Mileage Expense" Related Links: Related Code Snippets:
![]() |
![]() |
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2025 psoug.org |