![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() 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 : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 59 users online © 2009 psoug.org |