January 20th, 2009
Column Function Combinations
Posted by
admin in
J. Column Functions
Column functions can be SELECTed with other column functions because they each return only one value.
Column functions can not be combined with SELECTed columns or scalar functions because, they return multiple rows.
If we have a table: INVENTORY_TBL
SELECT MIN(PEOPLE) AS MIN,
MAX(PEOPLE) AS MAX,
AVG(PEOPLE) AS AVG,
COUNT(PEOPLE) AS NOT_NULL,
COUNT(*) AS ALL
FROM INVENTORY_TBL;
Result Table:
Comments Off
